C#中的事务用法实例分析

ssharet

于 2016-04-19 21:26:41 发布

阅读量266

点赞数

直接用SQL语句创建事务, 当然不是什么稀奇事了, 好是好, 只是麻烦.

看看C#中怎么做吧:

         SqlTransaction Tran = DBConn.BeginTransaction(); 
        
         cmdTmp.Transaction = Tran; 
        
         try
        
         {  
        
         cmdTmp.CommandText = 
         "DELETE FROM xxx"
         ; 
        
         cmdTmp.ExecuteNonQuery(); 
        
         cmdTmp.CommandText = 
         "INSERT INTO xxx"
         ; 
        
         cmdTmp.ExecuteNonQuery(); 
        
         Tran.Commit(); 
        
         } 
        
         catch 
         (Exception ex) 
        
         { 
        
         Tran.Rollback(); 
        
         throw 
         ex; 
        
         } 
        
         finally
        
         { 
        
         Tran.Dispose(); 
        
         cmdTmp.Transaction = 
         null
         ;  
        
         }