Store Image in SQL Server - ASP

[murugesanks]

Hi,
How to store image in SQL Server Database using ASP & how to view it.
Please give me the code.
Bye
Murugesan

 

[vasah20]

You would need to store it as a BLOB type, then do a Response.BinaryWrite to view the image.

I would suggest storing the image in a folder, though, then just storing the file path in SQL.

The documentation that I've read says that storing images in a DB is generally a bad thing... and I think it has something to do with the significant decrease in speed.

Again - I could be wrong, since I have never stored binary types in a DB of any sort...

But if you really needed to store the images in the DB, store it into a BLOB column, then Response.BinaryWrite the output to view it.


leo