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






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 setQuery more columns and read result set
2.Read result set containing all columnsRead result set containing all columns
3.Execute complicated SQL query
4.Read value using OleDbDataReaderRead value using OleDbDataReader
5.Map database column name to OleDbDataReader
6.Format Data from OleDbDataReader