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

Related examples in the same category

1.	Query more columns and read result set
2.	Read result set containing all columns
3.	Execute complicated SQL query
4.	Read value using OleDbDataReader
5.	Map database column name to OleDbDataReader
6.	Format Data from OleDbDataReader

Reference data in OleDbDataReader by column name : OleDbDataReader « Database ADO.net « C# / C Sharp

Related examples in the same category