listnotes.aspx.cs

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

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 System.Xml;
using System.Xml.Xsl;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Text;
using System.IO;

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

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

			// SQL语句：注意FOR XML字句的用法
			string sqlCommand = "SELECT id, title, link, description, html, [order] " +
				"FROM note WHERE section_id = " + iSectionId.ToString() +
				" ORDER BY [order] FOR XML AUTO, ELEMENTS";

			// 根据SQL语句创建SQL命令对象
			DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);

			XmlReader reader = null;
			StringBuilder sb = new StringBuilder();

			try
			{
				// 获取XML方式的data reader
				reader = db.ExecuteXmlReader(dbCommand);
			}
			finally
			{
				if (dbCommand.Connection != null)
				{
					dbCommand.Connection.Close();
				}
			}
			
			// xslt转换
			XslCompiledTransform xslt = new XslCompiledTransform();
			xslt.Load(Server.MapPath("~/xsl/notes.xsl"));

			// 页面输出xslt转换的结果
			XmlWriter writer = new XmlTextWriter(Response.Output);
			xslt.Transform(reader, writer);
		}
	}
}