C# 事务处理的应用

public   void   ExecuteTrans()   
  {   
  SqlConnection   con   =   new   SqlConnection("。。。。。。。。。");   
  con.Open();   
  SqlTransaction   sqlTrans   =   con.BeginTransaction();   
    
  //可以做循环   
  try   
  {   
  ExecuteProcedure1(con,sqlTrans);   
  ExecuteProcedure2(con,sqlTrans);   
  sqlTrans.Commit();   
  }   
  catch   
  {   
  sqlTrans.Rollback();   
  }   
  finally   
  {   
  con.Close();   
  }   
  }

比如说你有下面的两个方法，分别执行两个存储过程   
    
  public   void   ExecuteProcedure1(SqlConnection   SqlConn,SqlTransaction   sqlTrans)   
  {   
  SqlCommand   com   =   new   SqlCommand("yourProcedurName",SqlConn,sqlTrans);   
  com.CommandType   =   CommandType.StoredProcedure;