Jquery、DropDownList、数据库 联动实现（二）

JQueryDropDownList.aspx.cs

 

public partial class JQueryDropDownList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DataTable dt = LoadData();
            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    DropDownList1.Items.Add(new ListItem(dr["CatalogName"].ToString(), dr["CatalogID"].ToString()));
                }
            }
        }
    }

    #region 数据绑定
    private DataTable LoadData()
    {
        try
        {
            SqlConnection sqlCn = new SqlConnection("server=5AF7ACA28380456//SQLSERVER;user id=sa;password=zxcv;database=MobileDB;max pool size=100");
            SqlDataAdapter adapter = new SqlDataAdapter("select CatalogID,CatalogName from Es_Catalog where ParentID = 10004", sqlCn);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            return dt;
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
    #endregion
}

AjaxQuarter.ashx

 

<%@ WebHandler Language="C#" Class="AjaxQuarter" %>

using System;
using System.Web;
using System.Text;
using System.Data;
using System.Data.SqlClient;
public class AjaxQuarter : IHttpHandler {
   
    public void ProcessRequest (HttpContext context) {
        context.Response.StatusCode = 200;
        context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
        DataSet ds = new DataSet("Catalog");
        string catalogID = context.Request.QueryString["CatalogID"].ToString();
        ds = GetQuarter(catalogID);
        context.Response.ContentType = "text/xml";
        context.Response.Charset = "utf-8";
        context.Response.Clear();
        string a = ds.GetXml().ToString();
        context.Response.Write("<?xml version=/"1.0/" encoding=/"utf-8/"?>/n " + ds.GetXml());
        context.Response.End();
    }
    public bool IsReusable {
        get {
            return false;
        }
    }
    #region 异步获取数据
    private DataSet GetQuarter(string catalogID)
    {
        try
        {
            string strSql = string.Format("select CatalogID,CatalogName from Es_Catalog where ParentID = {0}", catalogID);
            SqlConnection sqlCn = new SqlConnection("server=5AF7ACA28380456//SQLSERVER;user id=sa;password=zxcv;database=MobileDB;max pool size=100");
            SqlDataAdapter adapter = new SqlDataAdapter(strSql, sqlCn);
            DataSet ds = new DataSet();
            adapter.Fill(ds);
            return ds;
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
    #endregion
}