I have used webservice to fetch name in textbox through ajax autocomplete extender but when i call web service through master page itz not gets fired ,i also have used script manager on my page and had given srvice path , but still itz not working
this is my Web service method
[WebMethod]
public string[] GetAutoCompleteData(string username)
{
SqlConnection con = new SqlConnection("Server=172.16.0.3;Database=CallRegister;User ID=Swati;Password=swa@123");
con.Open();
string strQuery="select DISTINCT name from HrMaster where name LIKE '%'+@SearchText+'%'";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(strQuery,con);
da.Fill(ds);
con.Close();
List<string> cityList = new List<string>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cityList.Add(ds.Tables[0].Rows[i][0].ToString());
}
return cityList.ToArray();
}
}
this is my aspx page
<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/MasterPage.Master" CodeBehind="WebAjax.aspx.cs" Inherits="ERPOrganization.WebAjax" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
<link href="css/ui-lightness/jquery-ui-1.8.21.custom.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
SearchText();
});
function SearchText() {
$("#txtSearch").autocomplete({
source: function (request, response) {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "AutoComplete.asmx/GetAutoCompleteData",
data: "{'username':'" + extractLast(request.term) + "'}",
dataType: "json",
success: function (data) {
response(data.d);
},
error: function (result) {
alert("Error");
}
});
},
focus: function () {
return false;
},
select: function (event, ui) {
var terms = split(this.value);
terms.pop();
terms.push(ui.item.value);
terms.push("");
this.value = terms.join(", ");
return false;
}
});
$("#txtSearch").bind("keydown", function (event) {
if (event.keyCode === $.ui.keyCode.TAB &&
$(this).data("autocomplete").menu.active) {
event.preventDefault();
}
})
function split(val) {
return val.split(/,\s*/);
}
function extractLast(term) {
return split(term).pop();
}
}
</script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="~/AutoComplete.asmx" />
</Services>
</asp:ScriptManager>
<div class="ui-widget">
<label for="tbAuto">Enter UserName: </label>
<%----%>
<asp:TextBox ID="txtSearch" runat="server" Width="300px"></asp:TextBox>
</div>
<%----%>
</asp:Content>