display OLE object stored in database to visualbasic form using code

[vidhyaprem]

i have started a small project in visual basic regarding the stock details in our textile company.It has details like product id,product name,no of items,product picture etc.. so i have created a table called "products". I have stored the picture of the each product as a OLE object(Bitmap Image) in product table.I tried viewing my entire "product" table in Visual basic form by using data control.I used OLE control to view the products picture.till this ihave no problem.

my problem starts when there is need to view the "product" table thru coding rather then using datacontrol.the neccesity occurs when u have to view a particular product.at this time ii cannot find coding to display OLE object in the database to OLE control or any other controls(image and picture control) in the visual basic form.Also when i need to add new product in the existing stock there occurs a neccesity to store the OLE object(ie "product picture" selected from computer directory) displayed in the OLE control to the corresponding field in the "product" table.

hope i am clear about what i have explained.could you please help me to overcome this trouble.

[sashi]

i have started a small project in visual basic regarding the stock details in our textile company.It has details like product id,product name,no of items,product picture etc.. so i have created a table called "products". I have stored the picture of the each product as a OLE object(Bitmap Image) in product table.I tried viewing my entire "product" table in Visual basic form by using data control.I used OLE control to view the products picture.till this ihave no problem.

my problem starts when there is need to view the "product" table thru coding rather then using datacontrol.the neccesity occurs when u have to view a particular product.at this time ii cannot find coding to display OLE object in the database to OLE control or any other controls(image and picture control) in the visual basic form.Also when i need to add new product in the existing stock there occurs a neccesity to store the OLE object(ie "product picture" selected from computer directory) displayed in the OLE control to the corresponding field in the "product" table.

hope i am clear about what i have explained.could you please help me to overcome this trouble.

Hi there,

Run a simple search on thescripts, use "BLOB" OR "Long binary" as keywords. I have seen and answered few questions related to above question. Good luck & take care.