using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;

namespace _313_spring_2008_ADO_Intro
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb";

            OleDbConnection conn = new OleDbConnection(connectionString);
            conn.Open();
            Console.WriteLine("DB connection open");

            OleDbCommand cmd = new OleDbCommand("select * from contacts", conn);
            OleDbDataReader dr = cmd.ExecuteReader();

            while (dr.Read())
            {
                Console.WriteLine("{0} : {1,20}, {2,-20} : email={3}", dr[0], dr[2], dr[1], dr[6]);
            }

            conn.Close();
            Console.WriteLine("DB connection closed");
        }
    }
}