Error while retriving the pdf file from sqlserver DB

Naresh Babu Gopavaram

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();

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naresh Babu Gopavaram15y ago
i have used Fluent Nhibernate to intract with Db and getting Offer object in that offerPdf is type of byte[]
Naresh Babu Gopavaram15y ago
byte[]
Satish Bhat15y ago
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 Gopavaram15y ago
I am saving the converted file in OFFER_PDF_OFR varbinary(MAX)
Naresh Babu Gopavaram15y ago
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 Bhat15y ago
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 Gopavaram15y ago
No body is there to solve my problem?