PDF Files stored in SQL Server!?!?!

Question

Hi all I have a problem with Files stored in SQL Server. The PDF files are stored in the database in an Image field. I can get the file out of the database but when it opens Adobe Reader it gives an error saying the File is corrupt and cannot be fixed. I have Word documents in the same table and I can download them then show them. I can also display Images from the DB but not the PDFs. Can anyone please help me?? Thanks

Lee · Answer

Okay I found the solution. To download: Response.ContentType = dsPDF.Tables [ 0 ] .Rows [ 0 ][strPDFFileWordMime] .ToString (); Response.OutputStream.Write (( byte []) dsPDF.Tables [ 0 ] .Rows [ 0 ][imgPDFFileWordDoc] 0  Convert.ToInt32( dsPDF.Tables [ 0 ] .Rows [ 0 ][intPDFFileWordLength])); Response.AddHeader (Content-Dispositionattachment;filename= + dsPDF.Tables [ 0 ] .Rows [ 0 ][strPDFFileWordName] .ToString ()); Response.Flush (); Response.End (); and to Display: Response.ContentType = dsPDF.Tables [ 0 ] .Rows [ 0 ][strPDFFileWordMime] .ToString (); Response.OutputStream.Write (( byte []) dsPDF.Tables [ 0 ] .Rows [ 0 ][imgPDFFileWordDoc] 0  Convert.ToInt32 ( dsPDF.Tables [ 0 ] .Rows [ 0 ][intPDFFileWordLength])); Response.AddHeader (Content-Disposition inline;filename= + dsPDF.Tables [ 0 ] .Rows [ 0 ][strPDFFileWordName] .ToString ()); Response.Flush (); Response.End (); it's the word inline in the header that makes it work.