jQuery Autocomplete Getting Data From Database in ASP.Net

type: "POST",

contentType: "application/json; charset=utf-8",

url: "WebService.asmx/GetData",

data: "{'DName':'" + document.getElementById('txtSearch').value + "'}",

dataType: "json",

success: function (data) {

response(data.d);

},

error: function (result) {

alert("Error......");

}

});

}

});

});

</script>

</head>

Now go to Solution Explorer and add a Web Service to the project (for example, "WebService.asmx").

Now write the following code in the .cs file of the Web Service:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Services;

using System.Data.SqlClient;

/// <summary>

/// Summary description for WebService

/// </summary>

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

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

// 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 WebService : System.Web.Services.WebService

{

[WebMethod]

public List<string> GetData(string DName)

{

List<string> result = new List<string>();

using (SqlConnection con = new SqlConnection("Data Source=SYSTEM-30;database=DB_Test_Trainees;user id=test;password=Test"))

{

using (SqlCommand cmd = new SqlCommand("select Dname from DEPTDHII where Dname like '%'+@SearchText+'%'", con))

{

con.Open();

cmd.Parameters.AddWithValue("@SearchText", DName);

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())

{

result.Add(dr["DName"].ToString());

}

return result;

}

}

}

}

Now check this line in the code above:

[System.Web.Script.Services.ScriptService]

By default this line is commented. To allow this Web Service to be called from a script using ASP.NET AJAX, uncomment the line.

Now build your application. Enter a search query in the TextBox.