通過(guò)ADO.NET實(shí)現(xiàn)事務(wù)處理

    在數(shù)據(jù)庫(kù)連接上創(chuàng)建事務(wù)處理對(duì)象，然后調(diào)用事務(wù)處理對(duì)象來(lái)提交事務(wù)或回滾事務(wù)。簡(jiǎn)單的代碼：
    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);
    }
    }