如题!

解决方案 »

  1.   

    楼主,嵌套事务跟其他需要成对使用模式的东西都一样,典型有XmlTextWriter,
    还有,记得pascal语言中
    begin 
          
         begin
              。。
         end
        
    end那么嵌套事务:public void ExecuteSqlTransaction1(SqlConnection conn)
    {
         SqlTransaction trans=conn.BeginTransaction("SampleTransaction1");
           try
            {
                 。。//你的其他代码
                 ExecuteSqlTransaction1(conn);   //这时候就包含嵌套了!
                  
                 // Attempt to commit the transaction.
                transaction.Commit();
            }
            catch (Exception ex)
            {
                    transaction.Rollback();
              }
    }
    public void ExecuteSqlTransaction2(SqlConnection conn)
    {
         SqlTransaction trans=conn.BeginTransaction("SampleTransaction2");
           try
            {
                 。。//你的其他代码
                 // Attempt to commit the transaction.            transaction.Commit();
            }
            catch (Exception ex)
            {
                    transaction.Rollback();
              }
    }