using System;
using System.Data;
using System.Data.OleDb;
 
namespace csbook.ch15 {
 
   class Example15_2 {
 
      static void Main(string[] args) {
         string conString =
              @"Provider=Microsoft.JET.OLEDB.4.0;"
            + @"data source=c:\data\Northwind.mdb";
 
            
         // create an open the connection          
         OleDbConnection conn = new OleDbConnection(conString);
         conn.Open();
 
         // create the DataSet
         DataSet ds = new DataSet();
 
         // create the adapter and fill the DataSet
         OleDbDataAdapter adapter = 
            new OleDbDataAdapter("Select * from Customers", conn);
         adapter.Fill(ds);
 
         // close the connection
         conn.Close();
 
         DataTable dt = ds.Tables[0];
         foreach (DataRow dr in dt.Rows) {
            Console.WriteLine(dr["CompanyName"].ToString());
            }
         }
      }
   }
//http://en.csharp-online.net/Working_with_Data%E2%80%94Connecting_to_Access_using_OLE_DB