using System; 
using System.Data; 
using System.Data.SqlClient; 

namespace Chapter11 
{ 
   class CommandReader 
   { 
      static void Main() 
      { 
         // vytvo pipojen 
         SqlConnection conn = new SqlConnection(@" 
          server = .\sqlexpress; 
          integrated security = true; 
          database = northwind"); 

         // vytvo pkaz (s textem i pipojenm) 
         string sql = @"
          SELECT FirstName, LastName FROM Employees"; 

         SqlCommand cmd = new SqlCommand(sql, conn); 
         Console.WriteLine("Pkaz vytvoen a pipojen."); 

         try 
         { 
            // otevi pipojen 
            conn.Open(); 

            // prove dotaz 
            SqlDataReader rdr = cmd.ExecuteReader(); 

            while (rdr.Read()) 
            { 
               Console.WriteLine("Jmno zamstnance: {0} {1}", 
                rdr.GetValue(0), 
                rdr.GetValue(1)); 
            } 
         } 
         catch (SqlException ex) 
         { 
            Console.WriteLine(ex.ToString()); 
         } 
         finally 
         { 
            conn.Close(); 
            Console.WriteLine("Pipojen uzaveno."); 
         } 
      } 
   } 
} 
