...

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



keerthy
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 :)

abduraooft
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.

alykins
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)

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum