visual web developer 2005. vb.

I have a label that is being populated from a checklistbox on a previous page. If I have one item selected and the label = P3; the "WHERE DocType IN (@DocType)) in my gridview of a SQL table is working fine. When more then one item is selected and the label = P3,P4 ;I am not getting any records in my gridview. Please help!!!! I've tried to put single quotes around the values, but that does not work.

When you have multiple values, what does your SQL Statement literally equate to?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

In SQL the multi value string will result in something like this:

   WHERE DocType IN ("P3,P4")

This is treated as a single value. This what you need:

   WHERE DocType IN ("P3","P4")

This is two distinct values within the IN clause.

The problem is that you can not use a single SQL parameter to pass multiple values. You need to dynamically construct the SQL query.

-Peter

ok, I have the following to build my sql command which I belive is building correctly, but how do I get the SqlDataSource to have the statement in it?.

Dim selectcommand As String
        selectcommand = "SELECT * FROM [TMP_APAudit] WHERE "
        Dim loopcntr As Integer = 0
        Dim i As Integer
        For i = 0 To chktext.Items.Count - 1
            If chktext.Items(i).Selected Then
                If loopcntr = 0 Then
                    loopcntr += 1
                    selectcommand += "DocType = '" + chktext.Items(i).Value + "'"
                Else
                    selectcommand += " OR DocType = '" + chktext.Items(i).Value + "'"
                End If
            End If
        Next
        lblsqlcmd.Text = selectcommand

SqlDataSource
       <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AXDemoConnectionString %>"
            SelectCommand= ???>

OK... I finally figured it out. things are much easier when you know what to do. thanks.

So what's the answer? How'd you solve it?