Mega Code Archive

 

Categories / C# by API / System Data Oledb

 

OleDbDataReader GetInt32

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();         }      } }