How to retrieve an image and display from a table in Microsoft Access DB?

Here you go!

using System.Data;
using System.Data.OleDb;

The System.Data.OleDb namespace contains the components necessary to implement the OLE DB data provider.

OleDbConnection Myconnection = null;
OleDbDataReader dbReader = null;

Myconnection = new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source=C:\MyDatabase.mdb");
Myconnection.Open();

OleDbCommand cmd = Myconnection.CreateCommand();
cmd.CommandText = "SELECT * FROM ImageTable"; //adjust the where clause according to the ID
dbReader = cmd.ExecuteReader();

My ImageTable has the following schema

ImageTable

[img_id] is a seed (Auto Number)
[img_name] which is a text
[img_data] OLE Object
[img_contenttype] Text

You will be using image_id to retrive the particular image from the database.

if ( dr.Read()) //yup we found our image
{
Response.ContentType = dr["img_contenttype"].ToString();
Response.BinaryWrite( (byte[]) dr["img_data"] );
}

connection.Close();

As simple as a buffalow :)

AfterBurner
MCP

AfterBurner at 2007-9-8 >

Well even in this case it can be done in a pretty simiar fashion.

I am referencing you an artilcle in MSDN which does the same thing using nortwind database

http://msdn2.microsoft.com/library/y0h25we8(en-us,vs.80).aspx

There is another aricle at c-sharp corner which might help you in the work

http://www.c-sharpcorner.com/winforms/ImageViewerST.asp

Hopefully these two articles above will help and you can always fine tune the applications according to your needs

Best's

AfterBurner
MCP

AfterBurner at 2007-9-8 >

memStrm.Close();

AfterBurner at 2007-9-8 >