How to display oracle BLOB image in VB6 ? [message #241328] |
Tue, 29 May 2007 04:47 |
sunilraghavan_sunil
Messages: 1 Registered: May 2007
|
Junior Member |
|
|
Hi,
I've a created a table(Oracle 9i(9.0.1.1.1)) as follows
CREATE TABLE PICT(ID NUMBER,IMG BLOB)
I inserted value 1 in ID and a jpg image named lotus.jpg ( it is in c:\image folder) in IMG field.
I'm using VB6 as front end. It contains an image box named img1 and a command button named cmd1. How can I display the image (lotus.jpg) in the image box from the table PICT by clicking the command button? I don't want to place any other controls other than the above said controls(image box and command button).
Thanks in advance,
Sunil
|
|
|
Re: How to display oracle BLOB image in VB6 ? [message #262640 is a reply to message #241328] |
Tue, 28 August 2007 00:00 |
hasan_uiu
Messages: 18 Registered: August 2007 Location: Dhaka
|
Junior Member |
|
|
you can try the followings
1. get the image from the table by a select quarry.
2.the quarry result store in a result set, so transfer the image to image control.. like this
resultset = execute result quarry
vb_image_control.set = resultset.get()
the above syntax are not exact so find the exact syntax for VB the idea is the same
|
|
|