<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
SqlTransaction _Transact;
void page_load(Object Sender, EventArgs E)
{
String ConnectionString = "Server=localhost; Database=pubs; uid=sa; pwd=;";
String CommandText = "UPDATE authors SET state='PU' WHERE state='UT'";
String CommandText2 = "UPDATE authors SET au_id='1' WHERE au_id='2'";
SqlConnection _Connection = new SqlConnection(ConnectionString);
SqlCommand _Command = new SqlCommand();
try{
_Connection.Open();
_Transact = _Connection.BeginTransaction();
_Command.Connection = _Connection;
_Command.Transaction = _Transact;
_Command.CommandText = CommandText;
_Command.ExecuteNonQuery();
_Command.CommandText = CommandText2;
_Command.ExecuteNonQuery();
_Transact.Commit();
MessageLiteralControl.Text = "Transaction Successful!";
}catch (Exception Err){
_Transact.Rollback();
MessageLiteralControl.Text = "Transaction Failed!
" + Err.Message;
}
finally{
_Connection.Close();
}
}