Mega Code Archive

 

Categories / C# / ADO Database

 

Map database column name to OleDbDataReader

using System; using System.Data.OleDb; public class ReadFromOleDb {   [STAThread]   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();     int idxID = oReader.GetOrdinal("id");     int idxFirstName = oReader.GetOrdinal("firstname");     int idxLastName = oReader.GetOrdinal("lastname");     while(oReader.Read()) {       Console.WriteLine("{0} {1} {2}",         oReader.GetValue(idxID),         oReader.GetValue(idxFirstName),         oReader.GetValue(idxLastName));     }   } }