Pictures in a database 1

[capone67]

Does anyone know how to insert a picture into a database using an SQL statement? I also need to know how to retrieve that image from the database and load it into a picture box.

Ken

 

[koala15]

The only way I know is to write the contents of the picturebox to a temporary file, then read in the file (in banary mode) then use the AppendChunck method to build the field (which is an OLE field).

To get the picture back, you do the reverse except you use GetChunck instead of AppendChunck.

I have done it an the application works fine.

Do you need more info??

Greg. "Life is full of learning, and then there is wisdom"

 

[capone67]

I am gonna need moe info if I go this route. The image needs to be loaded into the database suing activer server pages and retrieved using a vb application. Does this complicate things?

Ken

 

[koala15]

Using ASP should not be a problem because:

1) To put the image in the DB: use "SavePicture" to write the image to a tempory file, then using "InputB" to read it in and for each InputB chunck using .AppendChunck (iteratively) to build the field.

2) To get the image from the DB: use .GetChunck to grab each part of the field and write it to a temp file then use the "LoadPicture" function to save the image.

The documentation in the MSDN is quite extensive on this.

Is this enough info?
"Life is full of learning, and then there is wisdom"

 

[MrMoocow]

I don't have inputb? Can you explain this a little more for mee, thanks Brad,

http://www.moosoft.cjb.net

Free mp3 player,games and more.