database sQl server ?

[pareshgh]

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

[Arild Fines]

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

[pareshgh]

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

Paresh