Use OleDbCommand to load data from Access database mdb : Access : ADO.Net C# Examples

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

class  MainClass
{
    [STAThread]
    static  void  Main(string[]  args)
    {
        string  ConnectionString  =  @"Provider=Microsoft.Jet.OLEDB.4.0;Data  Source=c:\\Northwind.mdb";
        string  SQL  =  "SELECT  *  FROM  Orders";

        OleDbConnection  conn  =  new  OleDbConnection(ConnectionString);

        OleDbCommand  cmd  =  new  OleDbCommand(SQL);
        cmd.Connection  =  conn;

        conn.Open();

        OleDbDataReader  reader  =  cmd.ExecuteReader();

        while  (reader.Read())  
        {
            Console.Write("OrderID:"+reader.GetInt32(0).ToString()  );
            Console.Write("  ,");
            Console.WriteLine("Customer:"  +  reader.GetString(1).ToString()  );
        }
        reader.Close();
        conn.Close();
    }
}