Transaction processing via Ado.net

ado| Transaction Processing

Creates a transactional object on a database connection, and then invokes a transaction object to commit the transaction or rollback the transaction. Simple code:

private void Button1_Click (object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection ("Data Source=192.168.2.200;uid=sa; password=;d atabase = Haierhr ");
Conn. Open ();
Enable transaction
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 ("Transaction commits successfully!") ");
}
catch (Exception ex)
{
Tran. Rollback ();
MessageBox.Show ("error!" +ex. message);
}
}