Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)delvpublished in(发表于) 2014/1/6 9:16:00 通过ADO.NET实现事务处理_[Asp.Net教程]
private void button1_Click(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=192.168.2.200;uid=sa; password=;database = HaierHR"); conn.Open(); //启用事务 SqlTransaction tran = conn.BeginTransaction(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = tran; try { cmd.CommandText = "UPDATE HRRollMain Set TotalMember=TotalMember-100 WHERE RollID = '2005070101'"; cmd.ExecuteNonQuery(); cmd.CommandText = "UPDATE HRRollSum Set TotalSumMember=TotalSumMember+100 WHERE RollSumID = '20050701'"; cmd.ExecuteNonQuery(); tran.Commit(); MessageBox.Show("事务提交成功!"); } catch(Exception ex) { tran.Rollback(); MessageBox.Show("Error!"+ex.Message); } }
来源:网络
赞