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

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

         // definuj skalrn dotaz 
         string sqlQry = @" 
          SELECT count(*) FROM Employees"; 

         // definuj povel INSERT 
         string sqlIns = @" 
          INSERT INTO Employees (FirstName, LastName) 
          VALUES ('Zachariah', 'Zinn')"; 

         // definuj povel DELETE 
         string sqlDel = @" 
          DELETE FROM Employees 
          WHERE FirstName = 'Zachariah' AND 
                LastName = 'Zinn'"; 

         // vytvo pkaz 
         SqlCommand cmdQry = new SqlCommand(sqlQry, conn); 
         SqlCommand cmdNon = new SqlCommand(sqlIns, conn); 

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

            // prove dotaz pro zjitn potu zamstnanc 
            Console.WriteLine(
             "Ped povelem INSERT: Poet zamstnanc: {0}\n", 
             cmdQry.ExecuteScalar()); 

            // prove povel pro vloen zamstnance 
            Console.WriteLine("Provdm povel: {0}", 
             cmdNon.CommandText); 
            cmdNon.ExecuteNonQuery(); 
            Console.WriteLine(
             "Po povelu INSERT: Poet zamstnanc: {0}\n", 
             cmdQry.ExecuteScalar()); 

            // prove povel pro smazn zamstnance 
            cmdNon.CommandText = sqlDel; 
            Console.WriteLine("Provdm povel: {0}", 
             cmdNon.CommandText); 
            cmdNon.ExecuteNonQuery(); 
            Console.WriteLine( 
             "Po povelu DELETE: Poet zamstnanc: {0}\n", 
             cmdQry.ExecuteScalar()); 
         } 
         catch (SqlException ex) 
         { 
            Console.WriteLine(ex.ToString()); 
         } 
         finally 
         { 
            conn.Close(); 
            Console.WriteLine("Pipojen uzaveno."); 
         } 
      } 
   } 
} 
