关于asp.net中的二级联动

使用到的表名 Usernm

列名 School、sorting


test.aspx

<body>
    <form id="form1" runat="server">
   <asp:ScriptManager ID="ScriptManager1" runat="server">
  </asp:ScriptManager>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
  <ContentTemplate>
        <asp:DropDownList ID="ddlprovince" runat="server" OnSelectedIndexChanged="ddlprovince_SelectedIndexChanged" AutoPostBack="True"></asp:DropDownList><br />
        <asp:DropDownList ID="ddlcity" runat="server"></asp:DropDownList>
     </ContentTemplate>
  </asp:UpdatePanel>
        </form>
</body>
</html>
test.aspx.cs

 protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                //绑定省
                SqlConnection con = new SqlConnection("server=***;database=***;uid=***;pwd=***");
  <span style="white-space:pre">		</span>con.Open();
                SqlCommand cmd = new SqlCommand("select School from Usernm group by School",con);
                SqlDataReader sdr = cmd.ExecuteReader();
                this.ddlprovince.DataSource = sdr;
                this.ddlprovince.DataTextField = "School";
                this.ddlprovince.DataValueField = "School";
                this.ddlprovince.DataBind();
                sdr.Close();
                //绑定市
                SqlCommand cmdcity = new SqlCommand("select sorting from Usernm where School='" + this.ddlprovince.SelectedValue + "' group by sorting",con);
                SqlDataReader sdr1 = cmdcity.ExecuteReader();
                this.ddlcity.DataSource = sdr1;
                this.ddlcity.DataTextField = "sorting";
                this.ddlcity.DataValueField = "sorting";
                this.ddlcity.DataBind();
                sdr1.Close();
                con.Close();
            }

        }
        protected void ddlprovince_SelectedIndexChanged(object sender, EventArgs e)
        {
            string proID = this.ddlprovince.SelectedValue;           <pre name="code" class="csharp"><span style="white-space:pre">	</span>    SqlConnection con = new SqlConnection("server=***;database=***;uid=***;pwd=***");
  <span>	</span>    con.Open();
SqlCommand cmd = new SqlCommand("select sorting from Usernm where School='" + proID + "' group by sorting", con); SqlDataReader sdr = cmd.ExecuteReader(); this.ddlcity.DataSource = sdr; this.ddlcity.DataTextField = "sorting"; this.ddlcity.DataValueField = "sorting"; this.ddlcity.DataBind(); sdr.Close();
<span style="white-space:pre">	</span>    con.Close();
}

 



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值