省市县级联问题？？

seven4634 2011-08-04 05:20:23

我下载了那个ajax控件用的CascadingDropDown 这个实现级联
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div style="text-align: right; height: 24px; width: 1233px;">
<a href="../Master/Index.aspx">用户管理</a>
<cc1:CascadingDropDown ID="cas1" runat="server" TargetControlID="ddlPro" PromptText="请选择"
ServicePath="../WebService.asmx" Category="pro" ServiceMethod="GetProvince">
</cc1:CascadingDropDown>
<cc1:CascadingDropDown ID="cas2" runat="server" TargetControlID="ddlCity" ServicePath="../WebService.asmx"
Category="city" ServiceMethod="GetCityByProvince" ParentControlID="ddlPro">
</cc1:CascadingDropDown>
<cc1:CascadingDropDown ID="cas3" runat="server" TargetControlID="ddlCounty" ServicePath="../WebService.asmx"
Category="count" ServiceMethod="GetAreaByCity" ParentControlID="ddlCity">
</cc1:CascadingDropDown>
省<asp:DropDownList ID="ddlPro" runat="server" >
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
市<asp:DropDownList ID="ddlCity" runat="server" >
</asp:DropDownList>
县<asp:DropDownList ID="ddlCounty" runat="server" >
</asp:DropDownList>

这是webservice.ASMX的代码

public CascadingDropDownNameValue[] GetProvince(string knownCategoryValues,string category) {
StringDictionary val = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
List<CascadingDropDownNameValue> list = new List<CascadingDropDownNameValue>();

DataSet ds = gl.GetList("");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
list.Add(new CascadingDropDownNameValue (ds.Tables[0].Rows[i]["PRONAME"].ToString(), ds.Tables[0].Rows[i]["PROCODE"].ToString()));
}
return list.ToArray();

}

public CascadingDropDownNameValue[] GetCityByProvince(string knownCategoryValues,string category) {
StringDictionary val = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
List<CascadingDropDownNameValue> list = new List<CascadingDropDownNameValue>();

string ProvinceId = val["pro"];

DataSet ds2 = gl.GetCity(ProvinceId);
if (ds2 != null && ds2.Tables[0].Rows.Count>0)

for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
list.Add(new CascadingDropDownNameValue(ds2.Tables[0].Rows[i]["CITYNAME"].ToString(), ds2.Tables[0].Rows[i]["CITYCODE"].ToString()));
}
return list.ToArray();

}

public CascadingDropDownNameValue[] GetAreaByCity(string knownCategoryValues,string category) {
StringDictionary val = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
List<CascadingDropDownNameValue> list = new List<CascadingDropDownNameValue>();

string city = val["city"];
DataSet ds3 = gl.GetArea(city);
if (ds3 != null && ds3.Tables[0].Rows.Count > 0)
{

for (int i = 0; i < ds3.Tables[0].Rows.Count; i++)
{
list.Add(new CascadingDropDownNameValue(ds3.Tables[0].Rows[i]["CITYNAME"].ToString(), ds3.Tables[0].Rows[i]["CITYCODE"].ToString()));
}

}
return list.ToArray();
}

我实在是不知道哪错了各位帮看看吧

...全文

166 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

seven4634 2011-08-05

打赏
举报

好了我知道了因为我在方法上忘加[WebMethod] 这个了呵呵谢谢各位啊

子夜__ 2011-08-04

打赏
举报

using System;

using System.Data;

using System.Configuration;

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;

using System.Data.SqlClient;



public partial class _Default : System.Web.UI.Page 

{

  protected void Page_Load(object sender, EventArgs e)

  {

  if (!this.IsPostBack)

  {

  //绑定省

  SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");

  con.Open();

  SqlCommand cmd = new SqlCommand("select * from provience", con);

  SqlDataReader sdr = cmd.ExecuteReader();

  this.ddlprovince.DataSource = sdr;

  this.ddlprovince.DataTextField = "proName";

  this.ddlprovince.DataValueField = "proID";

  this.ddlprovince.DataBind();

  sdr.Close();

  //绑定市

  SqlCommand cmdcity = new SqlCommand("select * from city where proID=" + this.ddlprovince.SelectedValue, con);

  SqlDataReader sdr1 = cmdcity.ExecuteReader();

  this.ddlcity.DataSource = sdr1;

  this.ddlcity.DataTextField = "cityName";

  this.ddlcity.DataValueField = "cityID";

  this.ddlcity.DataBind();

  sdr1.Close();

  con.Close();

  }





   



  }

  protected void ddlprovince_SelectedIndexChanged(object sender, EventArgs e)

  {

  string proID = this.ddlprovince.SelectedValue;

  SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");

  con.Open();

  SqlCommand cmd = new SqlCommand("select*from city where proID=" + proID, con);

  SqlDataReader sdr= cmd.ExecuteReader();

  this.ddlcity.DataSource = sdr;

  this.ddlcity.DataTextField = "cityName";

  this.ddlcity.DataValueField = "cityID";

  this.ddlcity.DataBind();

  sdr.Close();

  con.Close();



  }

}

ddlprovince 为省 dropdownlist ID

ddlcity 为市 dropdownlist ID

proName proID为表provience中的字段也就是省的

cityName cityID为市city表中的字段是市的

ddlprovince_SelectedIndexChanged为省的dropdownlist 选中事件触发绑定

数据库 Demo 完整

seven4634 2011-08-04