Hey everyone. I have an SqlDataSource that uses a session parameter in its select statement. Everything works fine with one value in the parameter (as shown below) but I would like to pass multiple values to my select statement and have had no luck. Has anyone ever done this? Or know some other way of achieving the same goal (to select based on multiple values)? Thanks in advance.

This is what I have now (that works):
Code:
    Me.Session("myweb_labDiagCodes") = 1
HTML Code:
        <asp:SqlDataSource ID="SqlDSDiagnosticCodes" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString %>" 
            SelectCommand="SELECT [code], [memo] FROM [icd9_codes] WHERE ([ID] = @ID) ORDER BY [code], [memo]">
            <SelectParameters>
                <asp:SessionParameter Name="ID" SessionField="myweb_labDiagCodes" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
And this is what I am trying to do:
Code:
    Me.Session("myweb_labDiagCodes") = {1,2,3,4}
HTML Code:
        <asp:SqlDataSource ID="SqlDSDiagnosticCodes" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString %>" 
            SelectCommand="SELECT [code], [memo] FROM [icd9_codes] WHERE ([ID] = @ID) ORDER BY [code], [memo]">
            <SelectParameters>
                <asp:SessionParameter Name="ID" SessionField="myweb_labDiagCodes" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>