using System;
using System.Data;
using System.Data.OleDb;
class CommandOleDbQuery
{
static void Main()
{
OleDbConnection thisConnection = new OleDbConnection("provider = microsoft.jet.oledb.4.0;data source = Employee.mdb;");
OleDbCommand thisCommand = new OleDbCommand("SELECT ID, FirstName FROM Employee",thisConnection);
try
{
thisConnection.Open();
OleDbDataReader thisReader = thisCommand.ExecuteReader();
while (thisReader.Read()) {
Console.WriteLine("Product ID and Name: {0} {1}",
thisReader.GetValue(0),
thisReader.GetValue(1));
}
}
catch (OleDbException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
thisConnection.Close();
Console.WriteLine("Connection Closed.");
}
}
}
|
