ASP.NET Discussion - displaying PDF files from the DB

Print Page | Close Window

displaying PDF files from the DB

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17710
Printed Date: 29 March 2026 at 12:51am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: displaying PDF files from the DB

Posted By: Leeb65
Subject: displaying PDF files from the DB
Date Posted: 02 January 2006 at 12:00pm

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

http://www.rheinsitemedia.de">

Replies:

Posted By: Leeb65
Date Posted: 02 January 2006 at 12:20pm

Okay, I found out how to do it:

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-Disposition", "attachment;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.

-------------
Lee

http://www.rheinsitemedia.de">