关于asp.net中的二级联动

最新推荐文章于 2019-07-08 09:43:56 发布

zhaowei_zhang

最新推荐文章于 2019-07-08 09:43:56 发布

阅读量728

点赞数

本文链接：https://blog.csdn.net/zhaowei_zhang/article/details/45967939

版权

使用到的表名 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();

}

zhaowei_zhang

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫