Mega Code Archive

 

Categories / C# / ADO Database

 

Reference data in OleDbDataReader by column name

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"]);       }     }   }