Storing Images

Bhaskara Varma
02-26-2002, 08:42 PM
hai everybody,
I want to know how to store jpeg and mpeg files in the sqlserver database. Which data type we need to use in database. And how to store the data in that data type. I saw that image datatype is there in sqlserver. But i don't know how to store the image files data in that datatype.
I want to retrieve those files in the visual basic application. How to do that . Please help.
Thanks in advance.

Thinker
02-26-2002, 09:39 PM
Yes, you would use the Image datatype field.
Download and look at the tutorial/project in this thread. (http://www.visualbasicforum.com/showthread.php?s=&threadid=11080)
Even though it is for Access, the GetChunk and AppendChunk
methods work exactly the same for SQL Server.

Bhaskara Varma
02-26-2002, 11:28 PM
Thank you Very much Thinker,
Really it is a good program. I am very happy. The code exactly satisfy my need. Thank you once again.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum