Download PDF from MY SQL database in asp.net

Imran Khan Pathan

Hey. I have one table in MySql Database. I have two field. documentBinary LongBlob documentContentType varchar My code to download file.

byte[] data = (byte[])Dt.Rows[0]["documentBinary"];
// encoding.GetBytes(Dt.Rows[0]["documentBinary"].ToString());// (byte[])Dt.Rows[0]["documentBinary"].ToString();

            System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
            response.ClearHeaders();
            response.ClearContent();
            response.Clear();
            //response.AddHeader("Content-Type", Dt.Rows\[0\]\["documentContentType"\].ToString());
            response.ContentType = Dt.Rows\[0\]\["documentContentType"\].ToString();
            response.AppendHeader("Content-Disposition",
                "attachment; filename=" + Dt.Rows\[0\]\["titel"\].ToString() + ".pdf; size=" + data.Length.ToString());

            response.BinaryWrite(data);
            response.Flush();
            response.End();

When I download file,File is downloaded successfully but not open in pdf format. Please look at my code and tell me where I am going wrong. Thanks Imrankhan

please don't forget to vote on the post that helped you.

Sathesh Sakthivel

Whether PDF is installed in your system.

Sathesh. Blessed is the season which engages the whole world in a conspiracy of love.

Imran Khan Pathan

Yes. It is installed. When I open file it shows me that file is corrupted. Thanks Imrankhan

please don't forget to vote on the post that helped you.

Sathesh Sakthivel

Check by check points and find can u you able to retreive the data from MYSQL.

Sathesh. Blessed is the season which engages the whole world in a conspiracy of love.

Imran Khan Pathan

Sathesh Sakthivel wrote:

Check by check points and find can u you able to retreive the data from MYSQL.

Everything works file, file is created also, but does not open. It shows me that file is corrupted or not supported.

please don't forget to vote on the post that helped you.