As you learnt from the previous articles to upload image to the SQL Database in ASP.Net 2.0 and stream that image into the memory to retrieve it from the database and display it on the web page. In this article you will learn how to upload images to the MS Access database in ASP.Net 2.0

First of all create an Access Database and place it in the App_Data folder of ASP.Net web site project. Then create a table “tblImg” with the following fields:

1. img_id datatype number
   
   
2. img_title datatype Text
   
   
3. img_type datatype Text
   
   
4. img_stream datatype OLE Object

Notice the field img_stream, it has datatype OLE Object. In this field you can store the binary stream of the image passed by ASP.Net code.

To access the MS Access database you can use the following code:

To use OleDbConnection you must import the following namespaces:

Imports System.Data

Imports System.Data.OleDb

To upload the image to the MS Access database field you can pass the binary stream through the OleDb Command Parameter of type OleDbType.Binary

continue next...

VB Code to Upload Image to MS Access Database in ASP.Net

Store and Display Images from MS Access Database Using C#