Get column index from SqlDataReader : SqlDataReader « Database ADO.net « C# / C Sharp






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

Get column index from SqlDataReader

    using System;
    using System.Data.SqlClient;
  
  class ConnectToSqlConnection {
    static void Main(string[] args)  {
      String sConn = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";

        String sSQL = "select id, firstname, lastname from Employee";

      SqlConnection oConn = new SqlConnection(sConn);
      oConn.Open();

      SqlCommand oCmd = new SqlCommand(sSQL, oConn);
      SqlDataReader 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.Execute multiple SELECT statements using a SqlCommand object and read the results using a SqlDataReader object
2.use the GetOrdinal() from DataReader to get the numeric positions of a column
3.how to read column values as C# types using the Get* methods
4.read column values as Sql* types using the GetSql* methods
5.Read data from SqlDataReader
6.Reference data in SqlDataReader by column name
7.Use A Data Reader
8.Use While loop to read query result data from SqlDataReader
9.Deal with Multiple Results
10.SqlDataReader Ordinal Indexer