Want to load a picture from database

[KhushiRaina]

Hi all,
Hey how can i load picture field from database.I know it can be done from local disk but i wanted from database to show it on image or picture control.
Any Suggestions.....

Khushi

 

[phzero]

Hi Khushi,

What kind of database are you using?
SQL Server 7.0 / 2000
MSAccess
Flat File
FoxPro
...

 

[CCLINT]

If the image is stored in the db, as oppesed to a link to an image, or a file name being stored, then use the GetChunk method under ADO to get the long binary data and put it into a temp file. The rest you say you know already.
Thread709-391834

Under DAO use the OLE container control.

 

[strongm]

It is also possible to avoid use of GetChunk and the necessity of using a temporary file by using an ADO stream, and the fact that OLE pictures are persistable...

 

[CCLINT]

I think I touched upon using an ADO Stream in that thread, or somewhere else, but that was basically saving the picture back to the DB from a file.

 

[strongm]

You do indeed mention streams there (and also make the important point that large BLOBS impact SQL Server performance).