use an OleDbCommand object to read data from Access database : Access « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. Access

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();
    }
}