通过ADO.NET实现事务处理
在数据库连接上创建事务处理对象,然后调用事务处理对象来提交事务或回滚事务。简单的代码:
1
private void button1_Click(object sender, System.EventArgs e)
2
{
3
SqlConnection conn = new SqlConnection("Data Source=192.168.2.200;uid=sa; password=;database = HaierHR");
4
conn.Open();
5
//启用事务
6
SqlTransaction tran = conn.BeginTransaction();
7
SqlCommand cmd = new SqlCommand();
8
cmd.Connection = conn;
9
cmd.Transaction = tran;
10
try
11
{
12
cmd.CommandText = "UPDATE HRRollMain Set TotalMember=TotalMember-100 WHERE RollID = '2005070101'";
13
cmd.ExecuteNonQuery();
14
cmd.CommandText = "UPDATE HRRollSum Set TotalSumMember=TotalSumMember+100 WHERE RollSumID = '20050701'";
15
cmd.ExecuteNonQuery();
16
tran.Commit();
17
MessageBox.Show("事务提交成功!");
18
}
19
catch(Exception ex)
20
{
21
tran.Rollback();
22
MessageBox.Show("Error!"+ex.Message);
23
}
24
}
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
3
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
4
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
5
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
6
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
7
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
8
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
9
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
12
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
13
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
18
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
19
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
21
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
22
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
24
![](https://maxianghui.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
摘自:http://maxianghui.cnblogs.com/archive/2006/07/11/448173.html