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