Storing image to MSSQL2000 and read (VB60)

[BozaSpinoza]

Please help,
I need to store picture in MSSQL200 database, read and show that pisture after that but I dont'n know how.

1)How to get binary data from image file
2)How to parse that datas intu database (qry sintax)
3)How to get stored binary data and show that data as picture in image or picture box

I'm gratefull.

 

[fredericofonseca]

go to

http://www.vbxtras.com

and look at one of the controls available on the image related pages.


At least the following will allow you to use a image stored on a DB, and they will have examples of how to do it on VB.
IMGX
LEADTOOLS
Image Express (from PEGASUS)




Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[zemp]

One option that is commonly used is to store the path to the picture in the database as a string (varchar) rather than the image itself. The image is then stored by windows where ever the user likes. This is usually simpler than dealing with the image data types.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."