ASP.NET_事务的提交和回滚

1．合理使用事务提交(commited)和回滚 (undo)保证数据库完整。

SqlConnection conn = ...;
conn.Open();
SqlCommand cmd = conn.CreateCommand();
SqlTransaction tran = conn.BeginTransaction();
cmd.Transaction = tran;
try
   {
     cmd.CommandText = "insert into a (a) vlalues ('a')";
     cmd.ExecuteNonQuery();
     ...
     cmd.CommandText = "insert into b (b) vlalues ('b')";
     cmd.ExecuteNonQuery();
     ...
   }
catch (SqlException)
   {
     tran.Rollback();
     return;
   }
finally
 {
     conn.Close();
 }
tran.Commit();

2．检查是否出现异常#region 检查是否出现异常

          if (dal.ErrorMsg.Length > 2)

            {

                Functions.PageRegisterAlert(Page,"保存数据的时候出现意外情况，请与管理员联系！");

                return ;

            }

            Functions.PageRegisterAlert(Page,"保存成功！");

            #endregion