Click here to Skip to main content
15,868,306 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
C#
[WebMethod]
//[System.Web.Script.Services.ScriptMethod] 
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

XML
<%@ 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 () {
                    // prevent value inserted on focus
                    return false;
                },
                select: function (event, ui) {
                    var terms = split(this.value);
                    // remove the current input
                    terms.pop();
                    // add the selected item
                    terms.push(ui.item.value);
                    // add placeholder to get the comma-and-space at the end
                    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>
   <%--<input type="text" id="txtSearch" />--%>

    <asp:TextBox ID="txtSearch" runat="server" Width="300px"></asp:TextBox>



</div>

       <%--     <cc1:AutoCompleteExtender ID="ac1" runat="server" ServiceMethod="GetCode" MinimumPrefixLength="1"
                                DelimiterCharacters="," TargetControlID="txtAssign" CompletionListCssClass="AutoExtender"
             CompletionListItemCssClass="AutoExtenderList" ShowOnlyCurrentWordInCompletionListItem="true"
             CompletionListHighlightedItemCssClass
           ="AutoExtenderHighlight"
                                 Enabled="true" FirstRowSelected="true" EnableCaching="true"
                                CompletionSetCount="1" CompletionInterval="1000" CompletionListElementID="listPlacement1">
                            </cc1:AutoCompleteExtender>--%>
</asp:Content>
Posted
Updated 1-Jan-14 20:20pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900