当前文件： myAjaxDropdownlist/ChangelevelInfo.ashx[2K，2009-6-12 11:48:08]，打开代码结构图

		            
 1<%...@ WebHandler Language="C#" Class="ChangelevelInfo" %>
 2using System;
 3using System.Web;
 4using System.Xml;
 5using System.Data;
 6using System.Data.SqlClient;
 7
 8
 9public class ChangelevelInfo : IHttpHandler {
10    
11    public void ProcessRequest (HttpContext context) {
12       // context.Response.ContentType = "text/plain";
13        //context.Response.Write("Hello World");
14        context.Response.ContentType = "text/xml";
15        int pageindex = Convert.ToInt32(context.Request.QueryString["Page"]);
16        context.Response.Write(TVArray("死熊猫", pageindex).OuterXml);
17    }
18
19    //获得数据
20    public XmlDocument TVArray(string type, int pageindex)
21    {
22        string sqlstr = "";
23        int index = 1;
24        if (pageindex > 1)
25        {
26            index = (pageindex - 1) * 10;
27        }
28        if (pageindex == 1)
29        {
30          //sqlstr = "select top 10 a.Business_id,a.Business_name,a.Business_area,a.Business_sort,a.Business_company,a.Business_Wenhao,a.Business_Sxshijian,a.Business_liuyan,b.image_name from business a,member_up_image b where a.Business_Pdimage=b.id order by Business_id";
31            sqlstr = "select top 10 id,code,name,cityid from area order by id";
32        }
33        else
34        {
35           // sqlstr = "select top 10 a.Business_id,a.Business_name,a.Business_area,a.Business_sort,a.Business_company,a.Business_Wenhao,a.Business_Sxshijian,a.Business_liuyan,b.image_name from business a,member_up_image b where a.Business_Pdimage=b.id and (Business_id>(select max(Business_id) from (select top " + index + " Business_id from business  order by Business_id) as t)) order by Business_id";
36            sqlstr = "select top 10 id,code,name,cityid from area where (id>(select max(id) from (select top " + index + " id from area  order by id) as t)) order by id";
37        }
38        DataSet ds = SqlDataAccess.GetInfo(sqlstr);
39        string xmlds = ds.GetXml();
40        XmlDocument xml = new XmlDocument();
41        xml.LoadXml(xmlds);
42        return xml;
43    }
44
45    public bool IsReusable
46    {
47        get
48        {
49            return false;
50        }
51    }
52
53}