在數(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);
   }   
  }