C#执行SQL事务用法实例

                        cmd.Transaction = tran; //获取或设置将要其执行的事务  
                        try  
                        {  
                            //在try{}块里执行sqlconnection命令  
                            cmd.CommandText = "update bb set Moneys=Moneys-" + Money.Text + " where ID=" + ToID.Text;  
                            cmd.ExecuteNonQuery();  
                            cmd.CommandText = "update bb set Moneys=Moneys+" + Money.Text + " where ID=" + FromID.Text;  
                            cmd.ExecuteNonQuery();  
  
                            tran.Commit(); //如果两条sql命令都执行成功，则执行commit这个方法来执行这些操作。  
  
                            Msg.Text = "转账成功";  
                        }  
                        catch  
                        {  
                            Msg.Text = "转账失败";  
                            tran.Rollback();//如果执行不成功，发送异常，则执行rollback方法，回滚到事务操作开始之前。