Use to OleDbDataReader retrieve data : OleDbDataReader : ADO.Net C# Examples

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

class  MainClass
{
    static  void  Main(string[]  args)
    {
                string  ConnectionString  =  @"Provider=Microsoft.Jet.OLEDB.4.0;  Data  Source=c:\Northwind.mdb";
                string  SQL  =  "SELECT  *  FROM  Orders";

                OleDbConnection  conn  =  new  OleDbConnection(ConnectionString);              
                OleDbCommand  cmd  =  new  OleDbCommand(SQL);
                cmd.Connection  =  conn;

                conn.Open();
                OleDbDataReader  reader  =  cmd.ExecuteReader();
                try  
                {
                        while  (reader.Read())  
                        {
                                Console.Write("OrderID:"+reader.GetInt32(0).ToString()  );
                                Console.Write("  ,");
                                Console.WriteLine("Customer:"  +  reader.GetString(1).ToString()  );
                        }
                }
                finally  
                {
                        reader.Close();
                        conn.Close();
                }      
    }
}