Mega Code Archive
Refernece column name in SqlDataReader
<![CDATA[
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);
}
}
}
]]>