OleDbConnection.CreateCommand : OleDbConnection « System.Data.OleDb « C# / C Sharp by API

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

OleDbConnection.CreateCommand

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

class OleDbConnectionAccess {
    public static void Main() {
        string connectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=F:\\Program Files\\MicrosoftOffice\\Office\\Samples\\Northwind.mdb";

        OleDbConnection myOleDbConnection = new OleDbConnection(connectionString);

        OleDbCommand myOleDbCommand = myOleDbConnection.CreateCommand();

        myOleDbCommand.CommandText = "SELECT CustomerID, CompanyName, ContactName, Address FROM Customers WHERE CustomerID = 'ALFKI'";
        myOleDbConnection.Open();

        OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();

        myOleDbDataReader.Read();

        Console.WriteLine("myOleDbDataReader[\" CustomerID\"] = " + myOleDbDataReader["CustomerID"]);
        Console.WriteLine("myOleDbDataReader[\" CompanyName\"] = " + myOleDbDataReader["CompanyName"]);
        Console.WriteLine("myOleDbDataReader[\" ContactName\"] = " + myOleDbDataReader["ContactName"]);
        Console.WriteLine("myOleDbDataReader[\" Address\"] = " + myOleDbDataReader["Address"]);

        myOleDbDataReader.Close();
        myOleDbConnection.Close();
    }
}

   
    
  

Related examples in the same category