database sQl server ?

Hi,

I am dealing with several image files. I have a SQL-Server as a database server. how do I save these images in a table (as jpeg/bmp/gif) formats and later retrieve in the same format. ?

I need to store video also in database (NOT ON HARDDISK FILE).

any hints on this topic would be appreciated ...
Thanks,
Paresh

SQL server has an 'image' field type. Using this, you merely convert the image into an array of bytes(try saving it to a MemoryStream) and insert it the usual way.
The same goes for video(image can be used for any kind of binary data).

thanks ,
i will try to save images and let you know.

Paresh