save Image to sql database

[Hardik Shah]

Hi,

I want to save photograph of the customer to sql database, is there any
sample data base , any hints for storing image in SQL.

Thanks in advance.

Hardik Shah

 

[John Timney \( MVP \)]

Most people will tell you not to - and heres a good explanation why

http://www.sqlteam.com/item.asp?ItemID=986

 

[Cor Ligthert [MVP]]

Hardik,

In addition to John, it is not such a good idea, it is terrible slow.

However adding thumbnails in a database server is very nice, you can than in
a nice way manage your pictures.

However, here every thing you need to know about handling images and a
database. On our website is as well a sample how to make thumbnails from
images.

http://www.vb-tips.com/default.aspx?ID=0bf3f72d-b722-459d-8a46-38b5a2f7fdf0

I hope this helps,

Cor

 

[Guest]

Hi,

You can take a look at this URL:
http://blogs.msdn.com/jdixon/articles/495408.aspx
I used it to my ASP.NET 2.0 project and it stores the images in a Image
column type.

The only thing that doesn't seem to work within my project is to retreive
the image back from the DB.

Regards,
B.