getxml.aspx.cs

AJAX的一个学习实例

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Text;

namespace WebTest.ajaxSelect.code
{
	/// <summary>
	/// getXml 的摘要说明。
	/// </summary>
	public class getXml : System.Web.UI.Page
	{
		private void Page_Load(object sender, System.EventArgs e)
		{
			Response.Write(GetData());
			Response.End();
		}

		private string GetData()
		{
			/*-------------------设置参数------------------*/

			string tblName  = "T_user";
			string fldName  = "F_Id";						//自动编号ID字段
			string idFldName = "F_ClassID";					//条件过滤字段

			/*-------------------设置结束------------------*/

			long  PageSize	= Convert.ToInt32(Request.QueryString["pagesize"]);		//页大小
			long page		= Convert.ToInt32( Request.QueryString["page"]);		//当前页
			string id		= Request.QueryString["classID"];						//分类ID
			string key		= Request.QueryString["searchKey"];						//搜索关键字


			//int PageSize = 10;
			//int page=2;
			//string id="1";
			//string key = "3";

			string addkey	= "and F_ClassID like '%" + key + "%'or F_PassWord like '%" + key + "%' or F_UserName like '%" + key + "%'";
            int pageCount;

			string sql = "select count(*) from " + tblName + " where " + idFldName + "=" + id;
			if (key.Length > 0){sql += " " + addkey;}

			OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("db.mdb"));
			conn.Open();

			OleDbCommand cmd = new OleDbCommand(sql,conn);						//得到总记录数
			pageCount =Convert.ToInt32( Math.Ceiling((int)cmd.ExecuteScalar() / PageSize))	;				//得到总页			

			//排除的记录部分
			sql = "select top " + Convert.ToString((page - 1) * PageSize) + " " + fldName + " from " + tblName + " where " + idFldName + "=" + id;
			if (key.Length > 0){sql += " " + addkey;}

			sql = "select max (" + fldName + ") from ( " + sql + " ) as t"; //得到排除记录里的最大ID号
			sql = "select top " + PageSize.ToString() + " * from " + tblName + " where " + idFldName +"=" +id +" and " + fldName + ">(" + sql + ")";
			if (key.Length > 0){sql += " " + addkey;}
   
			if (page == 1)
			{
				sql = "select top " + PageSize + " * from " + tblName + " where " + idFldName + "=" + id;
				if (key.Length > 0){sql += " " + addkey;}
			}			
			
			StringBuilder sb = new StringBuilder();
			sb.Append("<?xml version=\"1.0\"?>");
			sb.Append("<NewDataSet>");
	
			OleDbDataAdapter da = new OleDbDataAdapter(sql,conn);
			DataSet ds = new DataSet();
			da.Fill(ds);
			conn.Close();
			for(int i = 0;i < ds.Tables[0].Rows.Count;i++)
			{
				sb.Append("<Table>");
				for(int j = 0; j < ds.Tables[0].Columns.Count; j++)
				{
					string ColumnName = ds.Tables[0].Columns[j].ColumnName;
					string ColumnValue = ds.Tables[0].Rows[i][j].ToString();
					sb.Append("<" + ColumnName + ">");
						sb.Append(ColumnValue);
					sb.Append("</" + ColumnName + ">");
				}
				sb.Append("</Table>");
			}
			sb.Append("<PageCount>");
				sb.Append(pageCount.ToString());
			sb.Append("</PageCount>");
			sb.Append("</NewDataSet>");
			return sb.ToString();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}