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

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

         // vytvo pkaz 
         SqlCommand cmd = new SqlCommand(); 
         Console.WriteLine("Pkaz vytvoen."); 

         try 
         { 
            // otevi pipojen 
            conn.Open(); 
         } 
         catch (SqlException ex) 
         { 
            Console.WriteLine(ex.ToString()); 
         } 
         finally 
         { 
            conn.Close(); 
            Console.WriteLine("Pipojen uzaveno."); 
         } 
      } 
   } 
} 
