C#筛选项联动,联动筛选
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillDep(); } // FillDG(); // if (!IsPostBack) // { // FillUI(); // } } <asp:Label ID="Label2" runat="server" Text="筛选1:"></asp:Label> <asp:DropDownList ID="DropDLOne" runat="server" AutoPostBack="true" OnSelectedIndexChanged="DropDLOne_SelectedIndexChanged"> </asp:DropDownList> <asp:Label ID="lblCType" runat="server" Text="筛选2:"></asp:Label> <asp:DropDownList ID="ddlTosofDept" runat="server" Width="86px"></asp:DropDownList> if (ddlTosofDept.Text != "全部") swhere += " and TosOfDept='" + ddlTosofDept.Text + "' "; private void FillDep() { DataTable DropDLTwo = new DataTable(); DropDLTwo = hrc.GetTableTwoList(" order by OrderIndex "); DropDLOne.Items.Clear(); DropDLOne.Items.Add("全部"); for (int i = 0; i < DropDLTwo.Rows.Count; i++) { DropDLOne.Items.Add(Convert.ToString(DropDLTwo.Rows[i].ItemArray[1])); } FillDept(); } private void FillDept() { DataTable dtTableOneList = new DataTable(); dtTableOneList = hrc.GetTableOneList(" where xxxxName='"+ DropDLOne.SelectedValue+ "' "); ddlTosofDept.Items.Clear(); ddlTosofDept.Items.Add("全部"); for (int i = 0; i < dtTableOneList.Rows.Count; i++) { ddlTosofDept.Items.Add(Convert.ToString(dtTableOneList.Rows[i].ItemArray[1])); } } protected void DropDLOne_SelectedIndexChanged(object sender, EventArgs e) { FillDept(); }