Showing PDF documents from a SQL Database

[dave wanta]

This is just off the top of my head, so let me know if it doesn't work. Be
gentle <grin>

Once you have the pdf bytes from the database, something like this *should*
work

byte[] bytes = GetPdfBytes(); //your function that gets the bytes from sql
server
Response.ContentType = "application/pdf"; //you may need to check the
exact Mime type of a pdf doc
Response.OutputStream.Write( bytes, 0, bytes.Length );
Response.End();

Cheers!
Dave
[url]www.aspNetPOP3.com[/url]
"Chris Roden" <croden@sterlingcapital.com> wrote in message
news:052101c3410a$81453260$a501280a@phx.gbl...

> I have PDF documents stored in a SQL Database. How can I
> display the PDF document straight from the database
> without creating a file?
>
> Chris Roden
>

[Yan-Hong Huang[MSFT]]

Hello Chris,

For how to get binary data from SQL server, you could refer to KB article:
"HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET"

If there is anything unclear, please feel free to post here.

Best regards,
yhhuang
VS.NET, Visual C++
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net? [url]http://www.gotdotnet.com[/url]
--------------------
!Content-Class: urn:content-classes:message
!From: "Chris Roden" <croden@sterlingcapital.com>
!Sender: "Chris Roden" <croden@sterlingcapital.com>
!Subject: Showing PDF documents from a SQL Database
!Date: Wed, 2 Jul 2003 19:26:27 -0700
!Lines: 6
!Message-ID: <052101c3410a$81453260$a501280a@phx.gbl>
!MIME-Version: 1.0
!Content-Type: text/plain;
! charset="iso-8859-1"
!Content-Transfer-Encoding: 7bit
!X-Newsreader: Microsoft CDO for Windows 2000
!Thread-Index: AcNBCoFFPLYeHP4CSNO/YIiiEFuC2w==
!X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
!Newsgroups: microsoft.public.dotnet.framework.aspnet
!Path: cpmsftngxa09.phx.gbl
!Xref: cpmsftngxa09.phx.gbl microsoft.public.dotnet.framework.aspnet:31912
!NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
!X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!
!I have PDF documents stored in a SQL Database. How can I
!display the PDF document straight from the database
!without creating a file?
!
!Chris Roden
!
!