欧美国产另类久热|951超碰伊人久久|伊人影视久久久久|色婷婷亚洲小电影|色东京热69XX|婷婷玖玖深爱网|加勒比东京热网站|无码A级毛片在线观看|一级a毛一级a看|中文字幕人妻欧美

在數(shù)據(jù)庫連接上創(chuàng)建事務(wù)處理對象，然后調(diào)用事務(wù)處理對象來提交事務(wù)或回滾事務(wù)。簡單的代碼：

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

//啟用事務(wù)

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("事務(wù)提交成功!");

}

catch(Exception ex)

{

tran.Rollback();

MessageBox.Show("Error!"+ex.Message);

}

}

更多信息請查看IT技術(shù)專欄