Retrive and store SQL Server Image Blob

sonamk

New member
Joined
Jun 19, 2007
Messages
2
Programming Experience
Beginner
i have a SQL sevrer database with the Images stored as BLOBs in the database which makes the database very bulky and large. Since i know that its not a good approach to store the images in the database i am trying to retrievve the images and store them as image in one folder and just store the path to the image in the database so that i could improve performance of the application i am developing. also the size of the image is very big.

i would be grateful if you could let me know :
1. how to retrieve the images and save them on the PC
2. how to resize the image ... it could be 5cm X 5 cm (Currently its direclty store at 5Megapixel resolution, dont remember the size)

a sample code would be highly appreciated.


best regards
 
Back
Top