SQL事务处理
int categoryID; string connectionString = WebConfigurationManager.ConnectionStrings
["Mydatabase"].ConnectionString;
using (TransactionScope scope = new TransactionScope())
{
using (SqlConnection connection = new SqlConnection(connectionString)) {
categoryID = InsertCategory(connection);
}
// 提交事务
http://www.77cn.com.cnplete();
}
lblResult.Text =
"Category is written successfully*****Category ID= " +
categoryID.ToString();
}
catch (Exception ex)
{
lblResult.Text = "Exception is : " + ex.Message;
}
}
int InsertCategory(SqlConnection connection)
{
}
</script>
<html xmlns="http://www.77cn.com.cn/1999/xhtml">