Code:
 <asp:SqlDataSource ID="SqlDataSource1" runat="server"ConnectionString="<%$ ConnectionStrings:ABCConnectionString %>"

SelectCommand="SELECT * FROM [Data] WHERE ([ActivityName] IN (@ActivityName)) AND ([ID] = @ID)" >

<SelectParameters>
<asp:ControlParameter ControlID="DropDownList_ID" Name="ID"
PropertyName="SelectedValue" Type="Int32" />

<asp:ControlParameter ControlID="LabelHidden" Name="ActivityName"
Type="String" />
</SelectParameters>

</asp:SqlDataSource>
The variable 'LabelHidden' contains a string of values: "'Production Technical Support', 'Tools Development'"

Manually, the sql query would run like this, for example:

SELECT * FROM [Data] WHERE ([ActivityName] IN ('PT Support', 'Tools Development')) AND ([ID] = 4)

It runs correctly when I use this query in SQL Management Studio, but will not run correctly from within my
SQLDataSource1.


Have you any advice or alternative suggestions?

I also tried with an event handler and OnSelecting, but got the same blank result.