Mega Code Archive

 

Categories / C# by API / System Data Oledb

 

CommandType TableDirect

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();                       } }