ASP.NET里的事务处理

myConnection.Open();

// 启动一个事务

SqlTransaction myTrans = myConnection.BeginTransaction();

// 为事务创建一个命令

SqlCommand myCommand = new SqlCommand();

myCommand.Connection=myConnection;

myCommand.Transaction = myTrans;

try

{

myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, "Description")";

myCommand.ExecuteNonQuery();

myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, "Description")";

myCommand.ExecuteNonQuery();

myTrans.Commit();

Console.WriteLine("Both records are written to database.");

}

catch(Exception e)

{

myTrans.Rollback();

Console.WriteLine(e.ToString());

Console.WriteLine("Neither record was written to database.");

}

finally

{

myConnection.Close();

}