Csharp/C Sharp by API/System.Data.OleDb/CommandType

CommandType.TableDirect

<source lang="csharp"> 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.rumandText = "Customers";
   cmd.rumandType = 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();                  
   }

}

 </source>