View Full Version : how to Add/delete/retrieve/update image in sql

01-10-2012, 03:04 PM
I'm doing mini project "online shopping" in asp.net with sql server 2000

i want to store images in sql and i want to retrieve it and display the image.

give me some easy tips and coding for that . . .

thank you :)

01-10-2012, 03:11 PM
Usually, the uploaded images are not stored in database as it may create some extra overhead to the server.

Instead, store the files in the directory with some unique names (to avoid overwriting) and then save the path of the files in database.

01-10-2012, 05:48 PM
i didn't read through it completely just scanned it real quick- ref (http://www.codeproject.com/KB/database/Store_and_manipulat_BLOBs.aspx)...
if that isn't it (should be though) the key word you are looking for is BLOB (binary large object)

01-11-2012, 02:24 PM
thanks for your tips & ideas :)