Asp.net 事务用法

　　SqlConnection myConnection = new SqlConnection("Data Source=localhost;Initial 　　Catalog=Northwind;Integrated Security=SSPI;");
　　myConnection.Open();

SqlTransaction myTrans = myConnection.BeginTransaction(); //使用New新生成一个事务
　　SqlCommand myCommand = new SqlCommand();
　　myCommand.Transaction = myTrans;

try
　　{
　　myCommand.CommandText = "Update Address set location='23 rain street' where userid='0001'";
　　myCommand.ExecuteNonQuery();
　　myTrans.Commit();
　　Console.WriteLine("Record is udated.");
　　}
　　catch(Exception e)
　　{
　　myTrans.Rollback();
　　Console.WriteLine(e.ToString());
　　Console.WriteLine("Sorry, Record can not be updated.");
　　}
　　finally
　　{
　　myConnection.Close();
　　}