how to retrieve and store image at runtime from oracel db

[sanctity4u]

HI, I m novice in Visual Basic. This is the first time putting thread in this forum. Hope I would get the positive reply for this thread.
I am student of MSC. I am developing a project of banking system on visual basic 6.0 with oracle database. I got some problem in this project.
i. I want to retrieve images from the hard drive into the image box at runtime and store its path or image in oracle database. I don’t know how to do it.
ii. Is it possible to hyperlink the address retrieved in the text box from the database in the form at run time.
Please help me so I can complete my project

[HanneSThEGreaT]

Have you written any code yet? If so, please show us some.

Have you heared of BLOBs? If you want to save the physical image into the database, you'll need to make use of them - do a search here on this forum, or a Google search, and you'll get plenty examples.

[sanctity4u]

No i hadn't written any code yet to retrieve and store image. because i am not getting any idea about it.

i heard about the blob but when i use it in my table. i am not able to use view the table data in oracle. some of the attributes and columns cannot be used here.

plz provide me the easiest code to store and retrieve image if som1 can.

one thing i more want to knw that , in my project i want to select any file from the hard drive and store the path in the text box and then in database.

please show some light on these problems.

[dglienna]

Post some of your project. Or, zip it up, and post an attachment