SqlConnection myConnection = new SqlConnection("Server=localhost;Database=***;uid=***;pwd=***;");
myConnection.Open();
// 启动一个事务
SqlTransaction myTrans = myConnection.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection=myConnection;
// 为事务创建一个命令
myCommand.Transaction = myTrans;
try
{
myCommand.CommandText = "Insert into class_title (title_name, num) VALUES (100, '100')";
myCommand.ExecuteNonQuery();
myCommand.CommandText = "Insert into class_title (title_name, num) VALUES (101, '100')";
myCommand.ExecuteNonQuery();
myTrans.Commit();
Response.Write("Both records are written to database.");
}
catch(Exception d)
{
myTrans.Rollback();
Response.Write(d.ToString());
Response.Write("Neither record was written to database.");
}
finally
{
myConnection.Close();
}
myConnection.Open();
// 启动一个事务
SqlTransaction myTrans = myConnection.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection=myConnection;
// 为事务创建一个命令
myCommand.Transaction = myTrans;
try
{
myCommand.CommandText = "Insert into class_title (title_name, num) VALUES (100, '100')";
myCommand.ExecuteNonQuery();
myCommand.CommandText = "Insert into class_title (title_name, num) VALUES (101, '100')";
myCommand.ExecuteNonQuery();
myTrans.Commit();
Response.Write("Both records are written to database.");
}
catch(Exception d)
{
myTrans.Rollback();
Response.Write(d.ToString());
Response.Write("Neither record was written to database.");
}
finally
{
myConnection.Close();
}