如果选择全部，则显示已完成和未完成的记录

user6429848 发表于 Dev

用户名

目前，我的下拉列表仅包含已完成和未完成。现在，我需要将所有内容以及完成和未完成添加到我的下拉列表中。

<asp:DropDownList ID="ddlstatus" runat="server" AutoPostBack="true" Width="120px" style="margin-left: 5px" OnSelectedIndexChanged="ddlstatus_SelectedIndexChanged" >
    <asp:ListItem Value="0">--Select--</asp:ListItem>
    <asp:ListItem Value="1">Done</asp:ListItem>
    <asp:ListItem Value="2">Not Done</asp:ListItem>
</asp:DropDownList>

山姆

试试这个

if (ddl2.SelectedIndex == 1)
{
    if (ddl3.SelectedItem.Text == "True")
    {
        query = "select M.name,M.ID,M.count,u.ID,sName from tblrecord Mts,data u,Type si where " +
         "u.name='" + ddl1.SelectedValue + "' and mts.name=u.id and si.ID= Mts.ID ";
    }
    else if (ddl3.SelectedItem.Text == "False")
    {
        query = "select M.name,M.ID,M.count,u.ID,sName from tblrecord Mts,data u,Type si where " +
         "u.name='" + ddl1.SelectedValue + "' and mts.name=u.id and si.ID= Mts.ID ";
    }
else 
    {
       query = "select M.name,M.ID,M.count,u.ID,sName from tblrecord Mts,data u,Type si where " +
         "u.name='" + ddl1.SelectedValue + "' and mts.name=u.id and si.ID= Mts.ID ";
    }
 }
else
{
    if (ddl3.SelectedItem.Text == "True")
    {
        query = "select M.name,M.ID,M.count,u.ID,sName from tblrecord Mts,data u,Type si where " +
         "u.name='" + ddl1.SelectedValue + "' and mts.name=u.id and si.ID= Mts.ID ";
    }
    else if (ddl3.SelectedItem.Text == "False")
    {
        query = "select M.name,M.ID,M.count,u.ID,sName from tblrecord Mts,data u,Type si where " +
         "u.name='" + ddl1.SelectedValue + "' and mts.name=u.id and si.ID= Mts.ID ";
     }
 else
    {
       query = "select M.name,M.ID,M.count,u.ID,sName from tblrecord Mts,data u,Type si where " +
         "u.name='" + ddl1.SelectedValue + "' and mts.name=u.id and si.ID= Mts.ID ";
     }
}