Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Use to OleDbDataReader retrieve data

using System; using System.Data; using System.Data.OleDb; class MainClass {   static void Main(string[] args)   {         string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\Northwind.mdb";         string SQL = "SELECT * FROM Orders";         OleDbConnection conn = new OleDbConnection(ConnectionString);                OleDbCommand cmd = new OleDbCommand(SQL);         cmd.Connection = conn;         conn.Open();         OleDbDataReader reader = cmd.ExecuteReader();         try          {             while (reader.Read())              {                 Console.Write("OrderID:"+reader.GetInt32(0).ToString() );                 Console.Write(" ,");                 Console.WriteLine("Customer:" + reader.GetString(1).ToString() );             }         }         finally          {             reader.Close();             conn.Close();         }      } } OrderID:10330 ,Customer:LILAS OrderID:10331 ,Customer:BONAP OrderID:10332 ,Customer:MEREP OrderID:10333 ,Customer:WARTH OrderID:10334 ,Customer:VICTE ...