Connect Table to OleDbCommand using CommandType.TableDirect : OleDbCommand : ADO.Net C# Examples

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

class  MainClass
{
    static  void  Main(string[]  args)
        {
        string  ConnectionString  =  @"Provider=Microsoft.Jet.OLEDB.4.0;  Data  Source=c:\Northwind.mdb";
        OleDbConnection  conn  =  new  OleDbConnection(ConnectionString);

        OleDbCommand  cmd  =  new  OleDbCommand();
        cmd.Connection  =  conn;
        cmd.CommandText  =  "Customers";

        cmd.CommandType  =  CommandType.TableDirect;
              
        conn.Open();
        OleDbDataReader  reader  =  cmd.ExecuteReader();

        Console.WriteLine("Customer  Id,  Contact  Name,  Company  Name");
                
        while  (reader.Read())
        {
            Console.Write(reader["CustomerID"].ToString());
            Console.Write(",  "+  reader["ContactName"].ToString());
            Console.WriteLine(",  "+  reader["CompanyName"].ToString());
        }
        
        reader.Close();
        conn.Close();                                    
        }
}