Mega Code Archive

 

Categories / C# / ADO Database

 

Read query result data from Access database

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.");          }       }    }