Showing documents stored in the database in the browser

[Guest]

i am in the process of designing an application that uploads documents to the
webserver from my ASP.net \ winforms application and saved them in the
database. Now i have another page which show hyperlinks points to the
document names that are stored in the database but the question when the user
clicks on the document how woudl i show the document to the user, if the
document was being saved on the file system then i would simply redirect the
user to the location of the document on the webserver and the brower then
invokes word if this is MS work document or pdf if this is a pdf extions or
what ever. but in this case when the document is store in the datbase how
would i pull the document from the database, pop open the MS word or PDF
depending on the file extension which is again comming from the database? any
suggestions or links to code is appreciated.

thanks
Sameer

 

[Steve C. Orr [MVP, MCSD]]

Basically you stream the file out to the response object and set the content
type appropriately.

I've documented the whole process in detail here:
http://SteveOrr.net/articles/EasyUploads.aspx