Reference data in SqlDataReader by column name : SqlDataReader : Database C# Source Code

Reference data in SqlDataReader by column name

    


    using System;
    using System.Data.SqlClient;

  class pubsdemo
  {
    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();

      while(oReader.Read()) {
        Console.WriteLine("{0} {1} {2}",
          oReader["id"],
          oReader["firstname"],
          oReader["lastname"]);
      }
    }
  }


           
       
    
   
  
   

Related in same category :
• Execute multiple SELECT statements using a SqlCommand object and read the results using a SqlDataReader object
• Get column index from SqlDataReader
• use the GetOrdinal() from DataReader to get the numeric positions of a column
• how to read column values as C# types using the Get* methods
• Read column values as Sql* types using the GetSql* methods
• Read data from SqlDataReader
• Use A Data Reader
• Use While loop to read query result data from SqlDataReader
• Deal with Multiple Results
• SqlDataReader Ordinal Indexer