全国省市县三级联动（数据完整版）

来源：互联网发布：mac键位编辑：程序博客网时间：2024/04/28 12:49

网页前台代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" EnableEventValidation="false"%>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<legend>全国省市县</legend>

<asp:DropDownList ID="DropDownList1" runat="server"

AutoPostBack="True">

</asp:DropDownList>

<cc1:CascadingDropDown ID="DropDownList1_CascadingDropDown" runat="server"

Category="provice" Enabled="True" LoadingText="读取数据中

.." PromptText="请选择省"

TargetControlID="DropDownList1" ServicePath="WebService.asmx" ServiceMethod="GetproviceNames">

</cc1:CascadingDropDown>

</fieldset>

<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True">

</asp:DropDownList>

<cc1:CascadingDropDown ID="DropDownList2_CascadingDropDown" runat="server"

Category="city" Enabled="True" TargetControlID="DropDownList2" LoadingText="读取数据中

.." PromptText="请选择市" ParentControlID="DropDownList1"

ServicePath="WebService.asmx" ServiceMethod="GetCityNames">

</cc1:CascadingDropDown>

</fieldset>

<asp:DropDownList ID="DropDownList3" runat="server">

</asp:DropDownList>

<cc1:CascadingDropDown ID="DropDownList3_CascadingDropDown" runat="server" Category="District" TargetControlID="DropDownList3"

Enabled="True" LoadingText="读取数据中

.." ParentControlID="DropDownList2"

ServicePath="WebService.asmx" ServiceMethod="GetDistrictNames">

</cc1:CascadingDropDown>

</fieldset>

</div>

</form>

</body>

</html>

WebService代码

using System;

using System.Collections;

using System.Linq;

using System.Web;

using System.Web.Services;

using System.Web.Services.Protocols;

using System.Xml.Linq;

//访问数据库命名空间

using System.Data;

using System.Data.SqlClient;

//访问web.config命名空间

using System.Web.Configuration;

//导入ScriptServiceAttribute类的命名空间

using System.Web.Script.Services;

//返回CascadingDropDownNameValue数组所需的命名空间

using AjaxControlToolkit;

using System.Collections.Generic;

using System.Collections.Specialized;

/// <summary>

///WebService 的摘要说明

/// </summary>

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

//若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。

[System.Web.Script.Services.ScriptService]

public class WebService : System.Web.Services.WebService

{

public WebService()

{

//如果使用设计的组件，请取消注释以下行

//InitializeComponent();

}

[WebMethod]

public CascadingDropDownNameValue[] GetproviceNames(string knownCategoryValues, string category)

{

List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();

SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Personal"].ConnectionString);

SqlCommand comm = conn.CreateCommand();

comm.CommandText = "select [ProvinceID],[ProvinceName] from [S_Province] order by 1";

conn.Open();

try

{

SqlDataReader dr = comm.ExecuteReader();

while (dr.Read())

{

values.Add(new CascadingDropDownNameValue(dr[1].ToString(), dr[0].ToString()));

}

return values.ToArray();

}

finally

{

conn.Close();

}

[WebMethod]

public CascadingDropDownNameValue[] GetCityNames(string knownCategoryValues, string category)

{

StringDictionary kcv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);

if (!kcv.ContainsKey("provice"))

{

return null;

}

List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();

SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Personal"].ConnectionString);

SqlCommand comm = conn.CreateCommand();

comm.CommandText = "select [CityID],[CityName] from [S_City] where [ProvinceID]=@ProvinceID order by 1";

comm.Parameters.Add("@ProvinceID", SqlDbType.Int).Value = kcv["provice"];

conn.Open();

try

{

SqlDataReader dr = comm.ExecuteReader();

while (dr.Read())

{

values.Add(new CascadingDropDownNameValue(dr[1].ToString(), dr[0].ToString()));

}

return values.ToArray();

}

finally

{

conn.Close();

}

[WebMethod]

public CascadingDropDownNameValue[] GetDistrictNames(string knownCategoryValues, string category)

{

StringDictionary kcv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);

if (!kcv.ContainsKey("city"))

{

return null;

}

List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();

SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Personal"].ConnectionString);

SqlCommand comm = conn.CreateCommand();

comm.CommandText = "select [DistrictID],[DistrictName] from [S_District] where [CityID]=@CityID order by 1";

comm.Parameters.Add("@CityID", SqlDbType.Int).Value = kcv["city"];

conn.Open();

try

{

SqlDataReader dr = comm.ExecuteReader();

while (dr.Read())

{

values.Add(new CascadingDropDownNameValue(dr[1].ToString(), dr[0].ToString()));

}

return values.ToArray();

}

finally

{

conn.Close();

}

数据库脚本下载链接：

http://files.cnblogs.com/dushouke/PCD_AllData_V1.rar