Reference data in OleDbDataReader by column name

image_pdfimage_print
   

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