Using Transaction

When we wat to use a transaction structure when connecting and updating a database, what we need to do is very simple:

SqlConnection con = new SqlConnection("...");
con.Open();
SqlTransaction trans = con.BeginTransaction();
try
{
string sql = "INSERT INTO ...";
SqlCommand command = new SqlCommand(sql, con, trans);
command.ExecuteNonQuery();
command.CommandText = "UPDATE ...";
command.ExecuteNonQuery();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
con.Close();
}