Downloading a file from SQL database

[shaqtus123]

A part of my website allows users to upload files to the SQL database. This file is saved in the database in binary format, and once it is saved, I want users to be able to download this file from the database. How can I write code to dynamically create a link to the file?

 

[ca8msm]

You will need to retrieve the object from the database and then write it out to the page/handler e.g.

Response.BinaryWrite(myImageByteArray)

Mark,

Darlington Web Design[tab]|[tab]Experts, Information, Ideas & Knowledge[tab]|[tab]ASP.NET Tips & Tricks

 

[shaqtus123]

That works, but it only displays the contents of the file in the browser. I need to be able to download the actual file. How can I do that?

 

[ca8msm]

If it displays the content of the file in your browser, that is because of your pc setup - some people may choose to have it open in an external program by default. If you want to change this behaviour you can change the content type to "application/octet-stream" and then it should prompt the open/save box by default.

Mark,

Darlington Web Design[tab]|[tab]Experts, Information, Ideas & Knowledge[tab]|[tab]ASP.NET Tips & Tricks

 

[shaqtus123]

When I do that, it strangely gives me a file dialog that is letting me download the .aspx file of the actual page. What's going on here?

 

[ca8msm]

You need to set the filename otherwise it will use the page name by default.

I'd also suggest that you try reading a few articles on the whole process so that you understand how it works.

Mark,

Darlington Web Design[tab]|[tab]Experts, Information, Ideas & Knowledge[tab]|[tab]ASP.NET Tips & Tricks