CommandType.TableDirect : CommandType « System.Data.OleDb « C# / C Sharp by API

1. C# / C Sharp by API
2. System.Data.OleDb
3. CommandType

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

   
    
    
  

Related examples in the same category