Autocomplete Box not working properly

Question

I have a set of 4 text boxes ,but My cylinder autocomplete textbox is not working.Please find attached my code and table structures and data.

Jefferson S. Motta · Answer

Hi, look for the fixes that I made for you (I), (I.1), (II), (III) and (IV): public static List string > GetAutoCompleteData( object paramSearchTerm) //(I) the type must be object { var SearchText = paramSearchTerm.ToString(); (I.1) // convert toString .. function SearchText() { $( ".autosuggest" ).autocomplete({ source: function (request, response) { $.ajax({ type: "POST" , contentType: "application/json; charset=utf-8" , url: "Default18.aspx/GetAutoCompleteData" , data: { searchTerm: "'" + request.term + "'" }, // the correct way to pass values (II) con.Open(); cmd.Parameters.AddWithValue( "@SearchText" , "'%" + searchTerm + "%'" ); (III) // pass the string to be searched SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) (IV) look how use the parameter using (SqlCommand cmd = new SqlCommand( "SELECT embid,pid,diereferneceno FROM job WHERE pid LIKE @SearchText " , con)) Fix all these things in all your code.

Autocomplete Box not working properly

Answers (1)