mailcontent.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 Db;

public partial class server_MailContent : System.Web.UI.Page
{
	protected void Page_Load(object sender, EventArgs e)
	{
		if (Request.QueryString["id"] != null)
		{
			// 邮件id号
			int mailId = Convert.ToInt32(Request.QueryString["id"]);

			// 查询SQL语句
			string strSql = string.Format("SELECT * FROM mail WHERE id = {0} ORDER BY [time] DESC FOR XML AUTO, ELEMENTS", mailId);

			// 创建LocalDbService对象，用于访问本机数据库
			DbService dbService = new LocalDbService();

			// 将查询结果转换为HTML代码，在页面上输出
			dbService.WriteMailList(strSql, Server.MapPath("~/xsl/content.xsl"), Response.Output);
		}
	}
}