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

class MainClass
{
  public static void Main()
  {
    string connectionString =
      "Provider=Microsoft.Jet.OLEDB.4.0;" +
      "Data source=Northwind.mdb"; // file in current directory
    OleDbConnection cnt = new OleDbConnection(connectionString);
   
    OleDbCommand cmd = cnt.CreateCommand();
    cmd.CommandText =
      "SELECT CustomerID, CompanyName, ContactName, Address " +
      "FROM Customers " +
      "WHERE CustomerID='ALFKI'";
   
    cnt.Open();
   
    OleDbDataReader dataReader = cmd.ExecuteReader();
   
    if (dataReader.Read())
    {
      //Display
      Console.WriteLine("CustomerID = "  + dataReader["CustomerID"]);
      Console.WriteLine("CompanyName = " + dataReader["CompanyName"]);
      Console.WriteLine("ContactName = " + dataReader["ContactName"]);
      Console.WriteLine("Address = "     + dataReader["Address"]);
   
      Console.WriteLine();
   
      // Display using method 2 - using index
      Console.WriteLine("Displaying using index");
      Console.WriteLine("CustomerID = "  + dataReader[0]);
      Console.WriteLine("CompanyName = " + dataReader[1]);
      Console.WriteLine("ContactName = " + dataReader[2]);
      Console.WriteLine("Address = "     + dataReader[3]);   
    }
   
    // wait
    Console.ReadLine();
  }
}