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(); } }
OrderID:10330 ,Customer:LILAS OrderID:10331 ,Customer:BONAP OrderID:10332 ,Customer:MEREP OrderID:10333 ,Customer:WARTH OrderID:10334 ,Customer:VICTE ... ...