using System; using System.Data.OleDb; class MapOleDbReader { static void Main(string[] args) { String sConn = "provider=sqloledb;server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI"; String sSQL = "select id, firstname, lastname from Employee"; OleDbConnection oConn = new OleDbConnection(sConn); oConn.Open(); OleDbCommand oCmd = new OleDbCommand(sSQL, oConn); OleDbDataReader oReader = oCmd.ExecuteReader(); while(oReader.Read()) { Console.WriteLine("{0} {1} {2}", oReader["id"], oReader["firstname"], oReader["lastname"]); } } }