Author: ezrollerr | Posted on: 3/29/2007 3:39:30 PM | Views : 309

Hi all:
I have implemented this autocomplete service which is working except that it does not return the correct matches. It always returns the first 12 (  CompletionSetCount="12") from the table no matter what I enter in the text box.

For some odd reason the match does not work..  
Here is my sql - it is a stored procedure that I am calling via a simple business logic which i am calling via (Dim mydb As New AcademicClasses.AcademicOperations)
The stored procedure simply returns all the fields in which I only loop through ISBNFromCPD in my code.

SELECT * FROM Books 
Here is my web service code:
 
 Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()

      
            Dim matches As New List(Of String)
    & ...

Go to the complete details ...