How to use an OleDbConnection object to connect to an Access database

   

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