Mega Code Archive

 

Categories / C# / ADO Database

 

Transaction roll back and commit

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();             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();          }       }    }