SQL事务处理
<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Transactions" %>
<%@ Import Namespace="System.Web.Configuration" %>
<script runat="server">
void btnSave_Click(object sender, EventArgs e)
{
CommittableTransaction trans = new CommittableTransaction(); try
{
string connectionString = WebConfigurationManager.ConnectionStrings
["Mydatabase"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString)) {
string sql = "Insert into Production.ProductCategory(Name," + "rowguid, ModifiedDate) Values(@Name, @rowguid, @ModifiedDate)"; // 打开连接，在事务范围中登记此连接
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
http://www.77cn.com.cnmandType = CommandType.Text;
SqlParameter nameParam =
new SqlParameter("@Name", SqlDbType.NVarChar, 50);
nameParam.Value = txtCategoryName.Text;
command.Parameters.Add(nameParam);
SqlParameter guidParam = new SqlParameter("@rowguid",
SqlDbType.UniqueIdentifier);
guidParam.Value = System.Guid.NewGuid();
command.Parameters.Add(guidParam);