Autocomplete textbox not working Asp.net

My Code

This Part Working Properly

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Script.Services;
namespace Product
{
///
/// Summary description for CustService
///
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class CustService : System.Web.Services.WebService
{
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public List<string> GetAutoCompleteData(string name)
{
List<string> result = new List<string>();
using (SqlConnection con = new SqlConnection(@"Data Source=KARUKUVELRAJ-PC\SQLEXPRESS;Initial Catalog=Product;Integrated Security=True"))
{
using (SqlCommand cmd = new SqlCommand("select DISTINCT name from customer where name LIKE '%'+@SearchText+'%'", con))
{
con.Open();
cmd.Parameters.AddWithValue("@SearchText", name);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
result.Add(dr["name"].ToString());
}
return result;
}
}
}
}
}

I Run This Code Not invoke it not Response, How to Clear this Problem

4 Replies

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

Ashutosh Gupta6y ago
check this link if that helps you
https://www.w3schools.com/howto/howto_js_autocomplete.asp
Salman Beg6y ago
Check these links for example,

https://www.aspsnippets.com/Articles/Implement-jQuery-AutoComplete-TextBox-from-database-using-AJAX-PageMethods-in-ASPNet.aspx

https://www.c-sharpcorner.com/blogs/autocomplete-textbox-in-asp-net1

Thanks.
dhoni kholi6y ago
no error show Webservice method Working Properly But I don't Know what happening
Salman Beg6y ago
First check whether you are getting any error or not. Second check whether it is calling GetAutoCompleteData method or not. Thanks.