use an OleDbCommand object to read data from Access database : Access : ADO.Net C# Examples

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

class  OleDbConnectionAccess  {
        public  static  void  Main()  {
                string  connectionString  =  "provider=Microsoft.Jet.OLEDB.4.0;data  source=F:\\Program  Files\\MicrosoftOffice\\Office\\Samples\\Northwind.mdb";

                OleDbConnection  myOleDbConnection  =  new  OleDbConnection(connectionString);

                OleDbCommand  myOleDbCommand  =  myOleDbConnection.CreateCommand();

                myOleDbCommand.CommandText  =  "SELECT  CustomerID,  CompanyName,  ContactName,  Address  FROM  Customers  WHERE  CustomerID  =  'ALFKI'";
                myOleDbConnection.Open();

                OleDbDataReader  myOleDbDataReader  =  myOleDbCommand.ExecuteReader();

                myOleDbDataReader.Read();

                Console.WriteLine("myOleDbDataReader[\"  CustomerID\"]  =  "  +  myOleDbDataReader["CustomerID"]);
                Console.WriteLine("myOleDbDataReader[\"  CompanyName\"]  =  "  +  myOleDbDataReader["CompanyName"]);
                Console.WriteLine("myOleDbDataReader[\"  ContactName\"]  =  "  +  myOleDbDataReader["ContactName"]);
                Console.WriteLine("myOleDbDataReader[\"  Address\"]  =  "  +  myOleDbDataReader["Address"]);

                myOleDbDataReader.Close();
                myOleDbConnection.Close();
        }
}