SqlConnection con = new
SqlConnection("Connection
String");
SqlCommand command1 = new SqlCommand(); //properly initiliased command with sql text or procedure
name
SqlCommand command2 = new
SqlCommand(); //properly
initiliased command with sql text or procedure name
SqlTransaction trx = conn.BeginTransaction();
command1.Transaction = trx;
command2.Transaction = trx;
try
{
command1.ExecuteNonQuery();
command2.ExecuteNonQuery();
trx.Commit();
}
catch (SqlException
ex)
{
trx.Rollback();
}
finally
{
//clean up resources
}
No comments:
Post a Comment