Refernece column name in SqlDataReader


using System;
using System.Data.SqlClient;

class FirstExample
{
  public static void Main()
  {
    try
    {
      SqlConnection mySqlConnection = new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI");

      SqlCommand mySqlCommand = mySqlConnection.CreateCommand();

      mySqlCommand.CommandText =  "SELECT id, firstname, lastname from employee";

      mySqlConnection.Open();
      SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();

      mySqlDataReader.Read();

      Console.WriteLine("mySqlDataReader[\" ID\"] = "+ mySqlDataReader["ID"]);
      Console.WriteLine("mySqlDataReader[\" First Name\"] = "+ mySqlDataReader["FirstName"]);
      Console.WriteLine("mySqlDataReader[\" Last Name\"] = "+ mySqlDataReader["LastName"]);

      mySqlDataReader.Close();

      mySqlConnection.Close();
    }
    catch (SqlException e)
    {
      Console.WriteLine("A SqlException was thrown");
      Console.WriteLine("Number = "+ e.Number);
      Console.WriteLine("Message = "+ e.Message);
      Console.WriteLine("StackTrace:\n" + e.StackTrace);
    }
  }
}

Related examples in the same category

1.	Geting Table column data type
2.	Read column values as Sql* types using the GetSql* methods
3.	Read column values as C# types using the 'Get' methods

Refernece column name in SqlDataReader : Table Column « Database ADO.net « C# / C Sharp

Related examples in the same category