Click here to Skip to main content
15,883,883 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi i wonder if anyone can help me i have a dropdownlist which has 3 options.
the 1st 2 options in single value but the 3rd option is multiple values but when i run the sql script it returns no data. below is the sample of the dropdownlist

ASP.NET
<asp:DropDownList ID="DropDownList1" runat="server">
            <asp:ListItem>--</asp:ListItem>
            <asp:ListItem>CO50</asp:ListItem>
            <asp:ListItem>COMP</asp:ListItem>
            <asp:ListItem Value="COMP,CO50">ALL</asp:ListItem>
        </asp:DropDownList>


and in my selectcommand i have the following

and MD IN :dropdownlistasp
and R.RCV_DATE between :datefrom and  :dateto

<SelectParameters>
                <asp:FormParameter FormField="dropdownlist1" 
                    Name="dropdownlistasp" />
                <asp:FormParameter FormField="textbox1" Name="datefrom" />
                <asp:FormParameter FormField="textbox2" Name="dateto" />
            </SelectParameters>

the 2 options which is single values return the correct data but the 3rd option with multiple values return nothing i have tried several values in the 3rd option and am not sure if it is possible

any assistance will be appreciated
thank you
Kallie
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900