deletenote.aspx.cs

来自「《征服Ajax》原书的例题源码」· CS 代码 · 共 39 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;

public partial class DeleteNote : System.Web.UI.Page
{
	protected void Page_Load(object sender, EventArgs e)
	{
		if (Request.Params["id"] != null)
		{
			// 书签id
			int iNoteId = Convert.ToInt32(Request.Params["id"]);

			// 数据库访问对象
			Database db = DatabaseFactory.CreateDatabase("DatabaseConnectionString");

			// 删除书签的存储过程DeleteNote
			string sqlCommand = "DeleteNote";
			DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

			// 增加存储过程的参数
			db.AddInParameter(dbCommand, "id", DbType.Int32, iNoteId);

			// 执行存储过程
			db.ExecuteNonQuery(dbCommand);
		}
	}
}