How to retrieve the blob image from oracle database.

Question

Hi I have a emp table with emp_idenameempimg as fields.I stored the empimg as blob in oracle database.I would like to know how to retrieve the blob image from database.I found so many online articles but everywhere they are having a separate table for image and retrieving the image based on image id. How to retrieve the image with emp_id.Is it really necessary to have a separate table for images? Sita.

suman reddy · Answer

Hi I hv saved the image into oracle DB using blob datatype.Now i require to retrive the image from the DB into asp.net image control . i'm working with asp.net(c#) with oracle databse . Image saved successfully. but i do not know how i will get the image in asp.net image control . So if any one have any solution plz share with me.. Regards suman.

sita k · Answer

Hi Satyapriya In the mentioned link he has taken a separate picturebox to retrieve the image.But i wanted to display it in the grid without taking any additional fields.I wanted to retrieve the image in the empImg column.

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/UploadFile/ehanth/Csharpdatabse03142006093738AM/Csharpdatabse.aspx