Download a file from a database

[MattB]

Can anyone point me to any good articles or examples of delivering a
binary file to the user from a database?
I need to pull a PDF file from a SQL Server image field and send it back
to the browser. I'm not sure if there is already an established "best
way" to do this so I thought I'd ask. I don't want to get too far down
the wrong path. Thanks!

Matt

[Ken Cox [Microsoft MVP]]

Hi Matt,

Is this what you're after?

HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET

http://support.microsoft.com/default...b;en-us;326502

Ken
Microsoft MVP [ASP.NET]

"MattB" <so********@yahoo.com> wrote in message
news:3d*************@individual.net...

Can anyone point me to any good articles or examples of delivering a
binary file to the user from a database?
I need to pull a PDF file from a SQL Server image field and send it back
to the browser. I'm not sure if there is already an established "best way"
to do this so I thought I'd ask. I don't want to get too far down the
wrong path. Thanks!

Matt

[Steve C. Orr [MVP, MCSD]]

Yes, this article shows you how to download files from a SQL Server
database.
It also shows you how to allow users to upload files into the database.

http://SteveOrr.net/articles/EasyUploads.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in message
news:e0**************@TK2MSFTNGP12.phx.gbl...

Hi Matt,

Is this what you're after?

HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET

http://support.microsoft.com/default...b;en-us;326502

Ken
Microsoft MVP [ASP.NET]

"MattB" <so********@yahoo.com> wrote in message
news:3d*************@individual.net...

Can anyone point me to any good articles or examples of delivering a
binary file to the user from a database?
I need to pull a PDF file from a SQL Server image field and send it back
to the browser. I'm not sure if there is already an established "best
way" to do this so I thought I'd ask. I don't want to get too far down
the wrong path. Thanks!

Matt

[Brad Roberts]

The ASP code was....

Response.ContentType = "application/pdf"
Response.BinaryWrite dr("Fieldname")
Response.end

I presume it would be about the same in .NET..

"MattB" wrote:

Can anyone point me to any good articles or examples of delivering a
binary file to the user from a database?
I need to pull a PDF file from a SQL Server image field and send it back
to the browser. I'm not sure if there is already an established "best
way" to do this so I thought I'd ask. I don't want to get too far down
the wrong path. Thanks!

Matt

[Brad Roberts]

' The ASP code was as follows
Response.ContentType = "application/pdf"
Response.BinaryWrite dr("Fieldname")
Response.end

I presume it will be about the same in .NET..

"MattB" wrote:

Can anyone point me to any good articles or examples of delivering a
binary file to the user from a database?
I need to pull a PDF file from a SQL Server image field and send it back
to the browser. I'm not sure if there is already an established "best
way" to do this so I thought I'd ask. I don't want to get too far down
the wrong path. Thanks!

Matt