事务处理(2)

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);

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库事务处理(2)在线全文阅读。