SQL事务处理
SqlParameter modifieDateParam = new SqlParameter("@ModifiedDate", SqlDbType.DateTime);
modifieDateParam.Value = System.DateTime.Now;
command.Parameters.Add(modifieDateParam);
//在当前事务的范围中登记事务
connection.EnlistTransaction(trans);
command.ExecuteNonQuery();
// 如果每一个执行都成功，则提交事务
http://www.77cn.com.cnmit();
}
lblResult.Text = "Category is written successfully";
}
catch (Exception ex)
{
// 如果出现异常，则回滚事务
trans.Rollback();
lblResult.Text = "Exception is : " + ex.Message;
}
}
</script>
<html xmlns="http://www.77cn.com.cn/1999/xhtml">
<head runat="server">
<title>Using Explicit Transactions using CommittableTransaction</title> </head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lblCategoryName" runat="server"