Mega Code Archive

 

Categories / C# by API / System Data Oledb

 

New OleDbCommand(String SQL)

using System; using System.Data; using System.Data.OleDb; class MainClass {   [STAThread]   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();     while (reader.Read())      {       Console.Write("OrderID:"+reader.GetInt32(0).ToString() );       Console.Write(" ,");       Console.WriteLine("Customer:" + reader.GetString(1).ToString() );     }     reader.Close();     conn.Close();   } }