Arraylist does return values when used in with clause

You want to get code value so you need to pass a single cID and if you need to pass multiple cID then use GridView or other Data container to show the details.

You can refer this link

http://www.aspforums.net/Threads/154508/Search-GridView-using-multiple-comma-separated-fields-in-ASPNet/

Its in C# and its vb translated code is

Private Sub WhereCondition()
    Dim id As String = txtId.Text.Trim()
    Dim employeesId As String() = id.Split(","c)
    Dim condition As String = String.Empty
    For Each item As String In employeesId
        condition &= item & Convert.ToString(",")
    Next

    Dim final As String = condition.Substring(0, condition.Length - 1)
    Me.GetEmployees(final)
End Sub

Private Sub GetEmployees(condition As String)
    Dim constr As String = ConfigurationManager.ConnectionStrings("conString2").ConnectionString
    Dim sqlStatment As String = (Convert.ToString("SELECT LastName,Country FROM Employees WHERE EmployeeID IN(") & condition) & ")"
    Using con As New SqlConnection(constr)
        Using cmd As New SqlCommand(sqlStatment, con)
            Using da As New SqlDataAdapter(cmd)
                Dim ds As New DataSet()
                da.Fill(ds)
                Me.gvEmployees.DataSource = ds
                Me.gvEmployees.DataBind()
            End Using
        End Using
    End Using
End Sub

Protected Sub Search(sender As Object, e As EventArgs)
    Me.WhereCondition()
End Sub

Image:

Thank You.