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: " + e.StackTrace); } } }