How to use an OleDbConnection object to connect to an Access database : Access « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. Access

How to use an OleDbConnection object to connect to an Access database

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=.\\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

1.	Connects to a Microsoft Access database
2.	Reading Access Data
3.	Use OdbcCommand to read data in Access database and fill the DataGrid
4.	Read query result data from Access database
5.	Connect to an Access database file