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

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

看看C#中怎么做吧:

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

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();

  throwex;

}

finally

{

  Tran.Dispose();

  cmdTmp.Transaction =null;

}