Data Binding: GridView & CheckBoxList & SQL

[rob]

Here is my scenario:

One of my aspx pages has a CheckBoxList (Item1, Item2) and a GridView.
Then I have a database that has the columns Item1 and Item2 (among
others) with the data type bit. What I am trying to do is to only show
the data sets chosen by the user. So for example if the user checks
Item1 in the CheckBoxList then only the datasets that have Item1 set to
True should be listed in the GridView. Here is what I tried:

Checkboxlist
------------
<asp:CheckBoxLi st OnSelectedIndex Changed="ItemsI ndexChanged
ID="CheckBoxLis tItems" RepeatColumns=" 2"
RepeatDirection ="Vertical"
RepeatLayout=Ta ble TextAlign="Righ t" Runat="server" >
<asp:ListItem>I tem1</asp:ListItem>
<asp:ListItem>I tem2</asp:ListItem>
</asp:CheckBoxLis t>

GridView
--------
<asp:GridView ID="GridView1" Runat="server"
DataSourceID="S qlDataSourceIte ms"
AutoGenerateCol umns="False" AllowSorting="T rue"
AllowPaging="Tr ue">
<Columns>
<asp:BoundFie ld HeaderText="Ite m1" DataField="Item 1"
SortExpression= "Item1">
</asp:BoundField>
<asp:BoundFie ld HeaderText="Ite m2" DataField="Item 2"
SortExpression= "Item2">
</asp:BoundField>
</Columns>
</asp:GridView>

SqlDataSource
-------------
<asp:SqlDataSou rce ID="SqlDataSour ceTssdSecFillin g" Runat="server"
SelectCommand=" SELECT * FROM [MyTable]
WHERE (([Item1] = @Item1) AND ([Item1] = @Item2))"
ConnectionStrin g="<%$ ConnectionStrin gs:AppConnectio nItems %>"
OnSelecting="Sq lDataSourceItem s_Selecting">
<SelectParamete rs>
<asp:ControlPar ameter Name="Item1"
ControlID="Chec kBoxListItems" Type="Boolean"
PropertyName="? ?????">
</asp:ControlPara meter>
<asp:ControlPar ameter Name="Item2"
ControlID="Chec kBoxListItems" Type="Boolean"
PropertyName="? ?????">
</asp:ControlPara meter>
</SelectParameter s>
</asp:SqlDataSour ce>

I just can't get this to work no matter what I set for the two
controlParamete rs in the SqlDataSource. It works just fine for a
TextBox. Any help is appreciated.

Regards,
Rob