using sql 2000 image in vb6

[baran121]

hi
i want to
Store and retrieve images in SQL Server 2000 using VB6.0
how can i do that?
please help me.

 

[HarleyQuinn]

I'd store the images elsewhere than SQLServer and store a path to the image in your DB.

The pseudocode would look like this:

'Retrieve Image
Open DB Connection
Select Image Path from DB
Close Connection
Use returned path to retrieve Image from location
Display image


'Store Image
Open DB Connection
Insert/Update image path into/in DB
Close Connection

Hope this helps



HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[baran121]

thank you
now it works like you said.
but i want to get image data from sql server.
and put image data to sql server

 

[HarleyQuinn]

To get you started, something like this?

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.