现有2个dropdownlist ddl_Province和ddl_City省和市分别存储在数据库表t_Province([ProvinceID], [ProvinceName])和t_City([CityID], [CityName], [ProvinceID])中如何操作,可以使ddl_Province选择省份的时候,在ddl_City中显示相应省份的城市
调试欢乐多
然后执行查询,查t_city表,将该省下面的城市取出来绑定..
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:DropDownList ID="ddlLB" runat="server" Width="15%" AutoPostBack="True" OnSelectedIndexChanged="ddlLB_SelectedIndexChanged">
</asp:DropDownList>
<asp:DropDownList ID="ddlChild" runat="server" Width="20%">
</asp:DropDownList>
</ContentTemplate>
</asp:UpdatePanel>
</div>
protected void ddlLB_SelectedIndexChanged(object sender, EventArgs e)
{
if(this.ddlLB.SelectedValue!=null)
{ }
}
可以考虑用ajax方式实现。
记得把AutoPostBack设置为true,如果想做无刷新就加个UpdatePanel
或用ajax
ajax就不比设置AutoPostBack=true