using System;
using System.Data;
using db = System.Data.OleDb;
// File: DataReaderUsingExecuteReaderOfCommandObject.cs(.txt)
// (Re)written  By: Dan Garlen February 2004
//  as part of a C# ADO.NET demonstration series
//  Requires: ConsoleUtilityRoutines.cs & C:\TestData\Northwind.mdb

namespace ADOdotNET_Demos
{
	public class DataReaderUsingExecuteReaderOfCommandObject
	{
      public static string strSQL = "SELECT * FROM [Customers]";
      public static string strMDB = "C:\\TestData\\Northwind.mdb";
      public static string strDB = "Provider=Microsoft.Jet.OLEDB.4.0;Data source =" + strMDB; 
      static void Main(string[] args)
      { 
         cur.Title("DataReader Using ExecuteReader of Command Object");
         Demo();  
         cur.Footer();
      }
      public static void Demo()
      {
         db.OleDbConnection cn = new db.OleDbConnection();
         cn.ConnectionString = strDB;
         try
         {
            db.OleDbCommand cmd;
            cmd = new db.OleDbCommand();
            cmd.CommandText = strSQL;  
            cmd.CommandType = CommandType.Text;  // This is the default type
            cmd.Connection = cn;
            cn.Open();
            db.OleDbDataReader dr;
            dr = cmd.ExecuteReader();
            while(dr.Read())
            { cur.WL("Company Name", dr.GetString(1)); }
            dr.Close(); cn.Close();
         }
         catch (Exception ex) {cur.WL("DB Error", ex.Message.ToString());}
      }
   }
}