implementing a progessive search in visual basic.net

Question

hi,i am having problem on how to implement such a thing , i am currently programming a compact framework vb.net this is what i have done and am stuck,what ive learn is very basic and simple i am using a sqlce query to use it to search for any string matching entries in the database and then it will display it something like google search engine.And am using visual studio 2005, what ive done is that i will use the datareader to search for the rows in the database and then i will have to assign them to something that is similar to google search engine a dropdown list of similiar results but am not sure how. What im doing is for the user to search for a particular salesman name and then have a progressive search function to also help the user to complete typing rather than typing the full words

  Public Class FinanceSalesManCom
    Dim connection As New SqlCeConnection("Data Source = \My Documents\finance.sdf")
    Private Sub txtSalesman_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtSalesman.TextChanged
        Dim enteredText As String = txtSalesman.Text
        Dim searchCmd As SqlCeCommand = connection.CreateCommand
        searchCmd.CommandText = "SELECT salesman FROM sales WHERE salesman LIKE '" & enteredText & "'% "
        connection.Open()
        Dim dr As SqlCeDataReader = searchCmd.ExecuteReader
        While dr.Read

        End While
        connection.Close()


    End Sub


        End Sub
End class

Answer 1

i think you are looking some thing like this

http://www.asp.net/ajax/ajaxcontroltoolkit/Samples/AutoComplete/AutoComplete.aspx