Autocomplete Box not working properly

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.