Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Use an OleDbCommand object to read data from 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=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();     } }