Map database column name to OleDbDataReader : OleDbDataReader « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. OleDbDataReader

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

           
       

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.	Reference data in OleDbDataReader by column name
6.	Format Data from OleDbDataReader