Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Reading Access Data with OleDbConnection

using System; using System.Data;             using System.Data.OleDb;       using System.Collections.Generic; using System.Text;   class Program{     static void Main(string[] args){            OleDbConnection thisConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");           thisConnection.Open();                OleDbCommand thisCommand = thisConnection.CreateCommand();                thisCommand.CommandText = "SELECT CustomerID, CompanyName FROM Customers";                OleDbDataReader thisReader = thisCommand.ExecuteReader();                while (thisReader.Read()){              Console.WriteLine("\t{0}\t{1}",              thisReader["CustomerID"], thisReader["CompanyName"]);           }           thisReader.Close();           thisConnection.Close();        }     }