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