weixin_41988954 2019-04-05 12:14 采纳率: 0%
浏览 334

三级联动代码省级市级都能出来可是区级不出来是为什么?有大神帮我解答一下吗

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using LoginAndRegist.DAL;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace LoginAndRegist
{
public partial class index : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["HasLogin"] == null || Convert.ToBoolean(Session["HasLogin"]) == false)
{
Response.Redirect("Login.aspx");
}
else if (Convert.ToBoolean(Session["HasLogin"]) == true)
{
if (!IsPostBack)
{
DataTable dt = DBHelper.GetDataSet(string.Format("select * from AreaInfo where ParentID='1'"));

                ddlProvince.DataSource = dt;
                ddlProvince.DataTextField = "AreaName";
                ddlProvince.DataValueField = "AreaID";
                ddlProvince.DataBind();

                ListItem li = new ListItem("未选择", "0");
                ddlProvince.Items.Insert(0, li);
                ddlCity.Items.Insert(0, li);
                ddlCounty.Items.Insert(0, li);
            }
        }

    }

    protected void ddlProvince_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataTable dt = DBHelper.GetDataSet(string.Format("select * from AreaInfo where ParentID='{0}'",ddlProvince.SelectedValue.ToString()));

        ddlCity.DataSource = dt;
        ddlCity.DataTextField = "AreaName";
        ddlCity.DataValueField = "AreaID";
        ddlCity.DataBind();

        ListItem li = new ListItem("未选择", "0");
        ddlCity.Items.Insert(0, li);

        ddlCounty.Items.Clear();
        ddlCounty.Items.Insert(0, li);
    }

    protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataTable dt = DBHelper.GetDataSet(string.Format("select * from AreaInfo where ParentID='{0}'",ddlCity.SelectedValue.ToString()));

        ddlCounty.DataSource = dt;
        ddlCounty.DataTextField = "AreaName";
        ddlCounty.DataValueField = "AreaID";
        ddlCounty.DataBind();

        ListItem li = new ListItem("未选择", "0");
        ddlCounty.Items.Insert(0, li);
    }
}

}

  • 写回答

1条回答 默认 最新

  • dlz1995 2019-04-09 09:54
    关注

    你调试下看下区有没有数据

    评论

报告相同问题?

悬赏问题

  • ¥15 如何实验stm32主通道和互补通道独立输出
  • ¥30 这是哪个作者做的宝宝起名网站
  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题