Commit Rollback Transaction

con.Open();
 SqlCommand cmd = new SqlCommand();
 cmd.Connection = con;
 SqlTransaction myTrans;
 myTrans = con.BeginTransaction();
 cmd.Transaction = myTrans;
if()
{
  myTrans.Commit();
}
else
{
  myTrans.Rollback();
}