asp.net textbox autocomplete

Hi,

Its very simple steps,just visit on my blog.

https://bikeshsrivastava.blogspot.in/2016/07/part-25how-to-implement-auto-complete.html

--------------------------------------------------------------------------------------------------

<System.Web.Script.Services.ScriptMethod(), _
System.Web.Services.WebMethod()> _
Public Shared Function SearchDepartement(ByVal prefixText As String, ByVal count As Integer) As List(Of String)
Try
Dim conn As SqlConnection = New SqlConnection
conn.ConnectionString = ConfigurationManager _
.ConnectionStrings("ficogesconn").ConnectionString
Dim cmd As SqlCommand = New SqlCommand
cmd.CommandText = "select Libelle from Departement where" & _
" Libelle like @SearchText + '%'"
cmd.Parameters.AddWithValue("@SearchText", prefixText)
cmd.Connection = conn
conn.Open()
Dim departements As List(Of String) = New List(Of String)
Dim sdr As SqlDataReader = cmd.ExecuteReader
While sdr.Read
departements.Add(sdr("Libelle").ToString)
End While
conn.Close()
Return departements
Catch ex As Exception

End Try

End Function

You can bind the textbox with onchange event and send an ajax request to server which will bring the list of data based on input and show an ui below the textbox.

 

see the below example-

onchange="GetItemDetails(this);"

$.post(url, { id: data }, function (response) {

//here bind data to the dropdown

})

 

you can also use the various jquery autocomplete library.

Hello diane,

Can you please put your code here so that we can come to know what you did exactly?