Mega Code Archive
How to use an OleDbConnection object to connect to an Access database
<![CDATA[
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();
}
}
]]>