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\n");
}
catch (System.Data.SqlClient.SqlException ex)
{
objTrans.Rollback();
Console.WriteLine("Error - TRANSACTION ROLLED BACK\n" + ex.Message);
}
catch (System.Exception ex)
{
Console.WriteLine("System Error\n" + ex.Message);
}
finally
{
cn.Close();
}
}
}
|