Error while retriving the pdf file from sqlserver DB

Question

I am saving the pdf file in sqlserver as bytes .When i am trying to retrive and show the file does not shows the content the following error occures

there was an error opening this document the file is damaged and could not be repaired +asp.net

Please any one help me

This is for save

byte[] byteArray = System.IO.File.ReadAllBytes(Server.MapPath("Deal//UI//pdfSample.pdf"));

savetoDB();

Retriving

byte[] document = (byte[])offer.OfferPdf;

//string strExtenstion = ".pdf";

string DocName = "pdfSample";

Response.ClearContent();

Response.AddHeader("content-disposition", "attachment;filename=" + DocName + ".pdf");

Response.AddHeader("content-length", document.Length.ToString());

Response.ContentType = "application/pdf";

//Response.TransmitFile("pdfSample.pdf");

Response.BinaryWrite(document);

//Response.Charset = "";

//Response.Cache.SetCacheability(HttpCacheability.NoCache);

//Response.Write(document);

Response.End();

Naresh Babu Gopavaram · Answer

i have used Fluent Nhibernate to intract with Db and getting Offer object in that offerPdf is type of byte[]

Naresh Babu Gopavaram · Answer

byte[]

Satish Bhat · Answer

What is the datatype of offer. OfferPdf. As per my understanding OfferPdf is the property of offer object? Are you using strongly typed dataset or custom business object. In both the cases what is the type of the OfferPdf.

Naresh Babu Gopavaram · Answer

I am saving the converted file in OFFER_PDF_OFR varbinary(MAX)

Naresh Babu Gopavaram · Answer

Thanks for ur replay  bu it is not workng showing the same error I am using the following code for retriving the file byte[] document = (byte[])offer.OfferPdf; //string strExtenstion = .pdf; string DocName = pdfSample; //Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = application/pdf; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AddHeader(content-disposition attachment;filename= + DocName + .pdf); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.AddHeader(content-length document.Length.ToString()); Response.Clear(); Response.BinaryWrite(document); Response.End();

Satish Bhat · Answer

1] Post the full code including savetoDB() & offer.OfferPdf retrieval & fill-up code. May be there's issue while saving the file in database and it might got corrupted. 2] What is the datatype and size of the field in SQL server database? is it varbinary(MAX)? 3] try using FileStream // Read in the file as a byte array string savedFilePath = @PDF_FILE_PATH; // use the file stream object to read the file from disk using (System.IO.FileStream fs = new System.IO.FileStream( savedFilePath  System.IO.FileMode.Open System.IO.FileAccess.Read)) { // store the file in a byte array that is the length of the file byte[] fileData = new byte[fs.Length]; // read in the file stream to the byte array fs.Read(fileData 0 System.Convert.ToInt32(fs.Length)); // close the file stream fs.Close(); // SAVE TO DATABASE }

Naresh Babu Gopavaram · Answer

No body is there to solve my problem?