Store & Retrieve Image using Access Database

Question

I have one Access Database and in one of the column I need to store image file, how can I do that? Can anyone help me. I know how to do this is MS SQL Server Database but not about Access Database. Can any one provide a sample code in C#.

Answer 1

Try using OLEObject

Answer 2

read Store images in a database. then you can retrieve and save image as byte array!

save

Image image = null;//assign your image here or use Bitmap image and assign image here!
byte[] imageBytes = null;//read below lines!

using(MemoryStream memoryStream = new MemoryStream())
{
    image.Save(memoryStream, ImageFormat.Jpeg);//save your image into stream you can change ImageFormat here!
    imageBytes = memoryStream.ToArray();//we have image bytes! insert bytes into your database!
}

load

byte[] imageBytes = null;//assign your image byte array!

Bitmap bitmap;
using(MemoryStream memoryStream = new MemoryStream(imageBytes))
{
    bitmap = new Bitmap(memoryStream);//here we construct an image from byte array!
}

---

Any fool can know. The point is to understand.(Albert Einstein)