Hai all
i tried below code for jq autocompletion .but it will call my webservice method and jumps for error...
$(document).ready(function () {
// var v = $('#txtsearch').val();
$("#txtsearch").autocomplete({
source: function (request, response) {
$.ajax({
type: "GET",
contentType: "application/json",
url: "Default2.aspx/GetCourseNames",
data: "{'Course': '" + $('#txtsearch').val() + "'}",
//'" + document.getElementById('txtsearch').value + "'
dataType: "json",
success: function (data) {
response(data.d);
},
error: function (result) {
alert("Error......");
}
});
}
});
and my .cs page is [System.Web.Services.WebMethod]
public List GetCourseNames(string Course)
{
List result = new List();
string s = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
SqlConnection con = new SqlConnection(s);
SqlCommand cmd = new SqlCommand("Sp_Search", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CName", Course);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
result.Add(dr["CourseName"].ToString());
}
return result;
i thought eveything is fine ....but it always jumps to error block while i m trying to enter text
any help
TIA
Vinay SinghPosted Jun 20, 2016, 2:18 AM
Autocomplete Textbox Using jQuery In Asp.Net and C#.Net