TextBox Autosuggest

[abhit_kumar]

Dear Experts,

Following is the code which working corretly when i type any character then its filter all the suggested string.

Now i does not want this, i want if suppose i type "pvt", then its suggest all the string which containg "pvt", eventhough it can be start from begining or in middle or in last.

    Private Sub CustomerName_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles CustomerName.Enter

        Try
            If Not myConnection.State = ConnectionState.Open Then
                myConnection.Open()
            End If

            da = New SqlDataAdapter("Select CustomerName from CustomerMaster", myConnection)
            da.Fill(ds, "CustomerMaster")
            Dim acFirstName As New AutoCompleteStringCollection
            For Each dr As DataRow In Me.ds.Tables("CustomerMaster").Rows
                acFirstName.Add(dr.Item("CustomerName").ToString)
            Next

            CustomerName.AutoCompleteSource = AutoCompleteSource.CustomSource
            CustomerName.AutoCompleteCustomSource = acFirstName

            myConnection.Close()

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

    End Sub

 

[jmcilhinney]

That's not how the inbuilt auto-complete functionality works. You'd have to provide the complete implementation yourself for that.