用DropDownList控件绑定XML数据实现省市区三级联动

 

用DropDownList控件绑定XML数据实现省市区三级联动(需要用到VS2005的Datasource和AJAX1.0),此方法仅用于学习讨论..

Citys.xml文件格式:

 

<?xml version="1.0" encoding="utf-8"?>
<PCitys>
  <Province pname="安徽省">
    <City cname="蚌埠市">
      <County name="蚌埠市"/>
      <County name="固镇县"/>
      <County name="怀远县"/>
      <County name="五河县"/>
    </City>
    <City cname="巢湖市">
      <County name="巢湖市"/>
      <County name="含山县"/>
      <County name="和县"/>
      <County name="庐江县"/>
      <County name="无为县"/>
    </City>
    <City cname="池州市">
      <County name="池州市"/>
      <County name="东至县"/>
      <County name="青阳县"/>
      <County name="石台县"/>
    </City>
  </Province>
</PCitys> 

前台显示代码(VS2005的AJAX1.0实现无刷新调数据):

 

<asp:ScriptManager id="ScriptManager1" runat="server"></asp:ScriptManager>
<asp:UpdatePanel ID="upPCC" runat="server">
                <ContentTemplate>
<asp:DropDownList ID="ddlProvince" runat="server" AppendDataBoundItems="True" AutoPostBack="True"
            DataSourceID="XmlDataSource1" DataTextField="pname" DataValueField="pname" OnSelectedIndexChanged="ddlProvince_SelectedIndexChanged">
            <asp:ListItem Selected="True">省份</asp:ListItem>
        </asp:DropDownList><asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/App_Data/Citys.xml"
            XPath="//Province"></asp:XmlDataSource>
        &nbsp;
        <asp:DropDownList ID="ddlCity" runat="server" AppendDataBoundItems="True" AutoPostBack="True"
            DataSourceID="XmlDataSource2" DataTextField="cname" DataValueField="cname" OnSelectedIndexChanged="ddlCity_SelectedIndexChanged">
            <asp:ListItem Selected="True">区市</asp:ListItem>
        </asp:DropDownList><asp:XmlDataSource ID="XmlDataSource2" runat="server" DataFile="~/App_Data/Citys.xml"
            XPath="//Province[@pname='']/City"></asp:XmlDataSource>
        <asp:DropDownList ID="ddlCounty" runat="server" AppendDataBoundItems="True" DataSourceID="XmlDataSource3"
            DataTextField="name" DataValueField="name">
            <asp:ListItem Selected="True">县市</asp:ListItem>
        </asp:DropDownList><asp:XmlDataSource ID="XmlDataSource3" runat="server" DataFile="~/App_Data/Citys.xml"
            XPath="//Province[@pname='']/City[@cname='']/County"></asp:XmlDataSource>
</ContentTemplate></asp:UpdatePanel>

 

后台代码:

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;

public partial class EmployeeAdd : System.Web.UI.Page
...{
    protected void Page_Load(object sender, EventArgs e)
    ...{
    }
    protected void ddlProvince_SelectedIndexChanged(object sender, EventArgs e)
    ...{
        ddlCity.Items.Clear();
        ddlCity.Items.Add("地市");
        ddlCity.DataTextField = "cname";
        ddlCity.DataValueField = "cname";
        XmlDataSource2.XPath = "//Province[@pname='" + ddlProvince.SelectedValue + "']/City";
        ddlCounty.Items.Clear();
        ddlCounty.Items.Add("县市");
    }
    protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
    ...{
        ddlCounty.Items.Clear();
        ddlCounty.Items.Add("县市");
        ddlCounty.DataTextField = "name";
        ddlCounty.DataValueField = "name";
        XmlDataSource3.XPath = "//Province[@pname='" + ddlProvince.SelectedValue + "']/City[@cname='" + ddlCity.SelectedValue + "']/County";
    }
}

ASP.NET2.0真是好,用DataSource控件简单解决了,不用写代码了.^_^