I have a Search as you type textbox that has been working great, but I just found a case where it is not working as intended. On a majority of names I am searching for, it works correctly. For example, if I was searching for Clark Kent, and typed in Kent it would pull up Clark Kent, I could click on it and everything would be good.
In a few names I have been typing in and it will "tack" what I am typing onto the names and not correctly get the ID. For example if I was searching for the name "Superman All American Hero" and I typed in Superman. I would see the following on my list
superman Superman All American Hero. It is not doing this for all names, just for random ones. Any Ideas why this might be happening? I am using a web Method to get the searches. It looks like this:
Public Function GetNameList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim SelectQry = "select * from Superheros where Name like '%" & prefixText & "%'"
Dim Results As New List(Of String)()
Using Command As New SqlCommand(SelectQry, Connection)
Using Reader As SqlDataReader = Command.ExecuteReader()
Dim Counter As Inte
View Complete Post