Autocomplete textbox not working Asp.net

Web service Code

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

{

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

[System.ComponentModel.ToolboxItem(false)]

public class CustService : System.Web.Services.WebService

{

[WebMethod]

[ScriptMethod(ResponseFormat = ResponseFormat.Json)]

public List GetAutoCompleteData(string name)

{

List result = new List();

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;

}

Form.aspx.cs Code

4 Replies

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

Ashutosh Gupta6y ago
check if this link can help you,,
https://www.w3schools.com/howto/howto_js_autocomplete.asp
0
Roshan Patil6y ago
The WebMethod GetAutoCompleteData should be static.
0
Salman Beg6y ago
When you are calling GetAutoComplete method from ajax call, then check whether it is calling or not. Put debugger and check whether you are getting error or not. Thanks.
0
Farhan Ahmed6y ago
https://youtu.be/tCr1p_InOe4
0