Read query result data from Access database : Access « Database ADO.net « C# / C Sharp





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



           
       










Related examples in the same category

1.Connects to a Microsoft Access databaseConnects to a Microsoft Access database
2.Reading Access Data
3.How to use an OleDbConnection object to connect to an Access database
4.Use OdbcCommand to read data in Access database and fill the DataGrid
5.Connect to an Access database file