Commit two delete sql command

   


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

   class SqlDemo {
      static void Main(){
         string connString = "server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";

         SqlConnection cn = new SqlConnection(connString);
         cn.Open();

         SqlTransaction objTrans = cn.BeginTransaction();

         try{
            SqlCommand cmd = cn.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.Transaction = objTrans;

            cmd.CommandText = "DELETE Employee WHERE Id = 222";
            cmd.ExecuteNonQuery();

            cmd.CommandText="DELETE Employee WHERE Id = 333";
            cmd.ExecuteNonQuery();

            objTrans.Commit();

            Console.WriteLine("Transaction Committed
");
         }
         catch (System.Data.SqlClient.SqlException  ex)
         {
            objTrans.Rollback();  

            Console.WriteLine("Error - TRANSACTION ROLLED BACK
" + ex.Message);
         }
         catch (System.Exception ex)
         {
            Console.WriteLine("System Error
" + ex.Message);
         }
         finally
         {
            cn.Close();  
         }
      }
   }