addnote.aspx.cs

《征服Ajax》原书的例题源码

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 AddNote : System.Web.UI.Page
{
	protected void Page_Load(object sender, EventArgs e)
	{
		if ((Request.Params["sid"] != null) &&
				(Request.Params["title"] != null) &&
				(Request.Params["link"] != null) &&
				(Request.Params["desc"] != null) &&
				(Request.Params["html"] != null) &&
				(Request.Params["order"] != null))
		{
			// 书签分类id
			int iSectionId = Convert.ToInt32(Request.Params["sid"]);

			// 书签标题
			string strTitle = Request.Params["title"];

			// 书签链接URL
			string strLink = Request.Params["link"];

			// 书签描述信息
			string strDesc = Request.Params["desc"];

			// 书签HTML代码
			string strHtml = Request.Params["html"];

			// 书签序号
			int iOrder = Convert.ToInt32(Request.Params["order"]);

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

			// 定义AddNote存储过程的对象
			string sqlCommand = "AddNote";
			DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

			// 增加存储过程的输入参数
			db.AddInParameter(dbCommand, "title", DbType.String, strTitle);
			db.AddInParameter(dbCommand, "link", DbType.String, strLink);
			db.AddInParameter(dbCommand, "description", DbType.String, strDesc);
			db.AddInParameter(dbCommand, "html", DbType.String, strHtml);
			db.AddInParameter(dbCommand, "section_id", DbType.Int32, iSectionId);
			db.AddInParameter(dbCommand, "order", DbType.Int32, iOrder);

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