Filtering Using Checkboxes.

Use a checkboxlist and then iterate through the items adding the checked ones to your query...

<asp:CheckBoxList ID="CheckBoxList1" runat="server" AutoPostBack="True">

<asp:ListItem>Pears</asp:ListItem>

<asp:ListItem>Oranges</asp:ListItem>

<asp:ListItem>Citrus</asp:ListItem>

</asp:CheckBoxList>

 

Protected Sub CheckBoxList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBoxList1.SelectedIndexChanged

For Each item As ListItem In CheckBoxList1.Items

If item.Selected Then

'add it to your SQL Query

End If

Next

End Sub

One more question on filtering. Here is my new code:
Protected Sub CheckBoxList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBoxList1.SelectedIndexChanged
        For Each item As ListItem In CheckBoxList1.Items
            gamesSqlDataSource.SelectParam eters("varSearch").DefaultValue = 1
            If item.Selected Then
                If item.Value = 1 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varAI").DefaultValue = 1
                End If
                If item.Value = 2 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varSI").DefaultValue = 1
                End If
                If item.Value = 3 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varII").DefaultValue = 1
                End If
                If item.Value = 4 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varCG").DefaultValue = 1
                End If
                If item.Value = 5 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varAO").DefaultValue = 1
                End If
                If item.Value = 6 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varSO").DefaultValue = 1
                End If
                If item.Value = 7 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varIO").DefaultValue = 1
                End If
                If item.Value = 8 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varWG").DefaultValue = 1
                End If
                If item.Value = 9 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varMG").DefaultValue = 1
                End If
                If item.Value = 10 Then
                &n bsp;   gamesSqlDataSource.SelectParameters("varTrick").DefaultValue = 1
                End If
            End If
        Next
    End Sub
My problem is that I also need it to check if an item is not checked. E.g., if checkbox for varTrick is unchecked then it needs to set gamesSqlDataSource.SelectParameters("varTrick").DefaultValue = 0. Otherwise, when I check the checkboxes everything works fine but when I uncheck them nothing changes. Any ideas?
David.

Good idea. I didn't think that was going to work. But after just spending the last few minutes writing a post to tell you why it wasn't going to work, I saw your logic and will let you know if it doesn't work...But I think it will. Thanks.
David.