Thursday, January 14, 2010

Implement Sql Transaction in ASP.net

SqlTransaction trans = null;
try
{
string conn = @"Data Source=.\SQLEXPRESS;Initial Catalog=ABC;Integrated Security=True";
using (SqlConnection connection = new SqlConnection(conn))
{
connection.Open();
trans = connection.BeginTransaction();
SqlCommand cmd = new SqlCommand("Command Text",connection, trans);
cmd.ExecuteNonQuery();
trans.Commit();
connection.Close();
}
}
catch (Exception ex)
{
if(trans!=null)
trans.Rollback();
}