i want to try and suugest list of company from sql server in a normal web form the code works but using in the master page it does not workBelow is the code ltaspTextBox ID34TextBoxSearchCompany34 class34formcontrol34 placeholder34Search company34 runat34server34gt ltaspAutoCompleteExtender ID34txtNameAutoCompleteExtender34 runat34server34

RefASPNet AJAX Control Toolkit AutoCompleteExtender without using Web ServicesI have kept the Ajax Auto complete Html code in master page and you need to place the Web Method inside any Content Page codePlease refer this codeMaster Pagelt Register Assembly34AjaxControlToolkit34 Namespace34AjaxControlToolkit34 TagPrefix34cc134 gtltDOCTYPE html PUBLIC 34W3CDTD XHTML 10 TransitionalEN34 34httpwwww3orgTRxhtml1DTDxhtml1transitionaldtd34gtlthtml xmlns34httpwwww3org1999xhtml34gtlthead runat34server34gt lttitlegtlttitlegt ltaspContentPlaceHolder ID34head34 runat34server34gt ltaspContentPlaceHoldergtltheadgtltbodygt ltform id34form134 runat34server34gt ltdivgt lth1gt Master Page lth1gt ltcc1ToolkitScriptManager ID34ScriptManager134 runat34server34 EnablePageMetho

ASP.Net AJAX AutoCompleteExtender using database in ASP.Net Master Page example

dmj044

SOLVED CLOSED ACTIVE ANSWERED
User: dmj044
Posted: on Feb 20, 2015 09:11 AM
Forum: ASP.Net AJAX
Answer: 1
Views: 10687

i want to try and suugest list of company from sql server. in a normal web form , the code works but using in the master page it does not work.

Below is the code

<asp:TextBox ID="TextBoxSearchCompany" class="form-control" placeholder="Search company..." runat="server"/>
                             <asp:AutoCompleteExtender 
                                  ID="txtName_AutoCompleteExtender"
                                  runat="server"
                                  DelimiterCharacters=""
                                  Enabled="True"
                                  ServicePath ="~/AutoComplete.asmx"
                                  ServiceMethod="GetCompletionList" 
                                  TargetControlID="TextBoxSearchCompany"
                                  MinimumPrefixLength="2"
                                  CompletionInterval="10"
                                  EnableCaching="true"
                                  CompletionSetCount="3"
                                 ContextKey="false">

                            </asp:AutoCompleteExtender>

then the webservice signature is

 [WebMethod]
        [System.Web.Script.Services.ScriptMethod]
        public static string[] GetCompletionList(string prefixText, int count, string contextKey)
        {
            string connectionString = ConnectionString.GetConStr();
            SqlConnection conn = new SqlConnection(connectionString);
            // Try to use parameterized inline query/sp to protect sql injection
            SqlCommand cmd = new SqlCommand("SELECT TOP " + count + " company FROM [vwCompanyLookup] WHERE company LIKE '" + prefixText + "%'", conn);
            SqlDataReader oReader;
            conn.Open();
            List<string> CompletionSet = new List<string>();
            oReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            while (oReader.Read())
                CompletionSet.Add(oReader["company"].ToString());
            return CompletionSet.ToArray();
        }

I added the following Ajax reference

<asp:ToolkitScriptManager EnablePageMethods="true" ID="ToolkitScriptManager1" runat="server">
        </asp:ToolkitScriptManager>

But when i run the app nothing shows.

what is wrong with my code ?

Azim

0 3

Reply
ANSWER
User: Azim
Replied: on Feb 20, 2015 11:38 PM
Report

Ref:

I have kept the Ajax Auto complete Html code in master page and you need to place the Web Method inside any Content Page code.

Please refer this code.

Master Page:

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <asp:ContentPlaceHolder ID="head" runat="server">
    </asp:ContentPlaceHolder>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h1>
            Master Page
        </h1>
        <cc1:ToolkitScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        </cc1:ToolkitScriptManager>
        <asp:TextBox ID="txtContactsSearch" runat="server"></asp:TextBox>
        <cc1:AutoCompleteExtender ServiceMethod="SearchCustomers" MinimumPrefixLength="2"
            CompletionInterval="100" EnableCaching="false" CompletionSetCount="10" TargetControlID="txtContactsSearch"
            ID="AutoCompleteExtender1" runat="server" FirstRowSelected="false">
        </cc1:AutoCompleteExtender>
        <asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
        </asp:ContentPlaceHolder>
    </div>
    </form>
</body>
</html>

Namespaces

using System.Data.SqlClient;
using System.Configuration;

Default.aspx.cs using master page.

[System.Web.Script.Services.ScriptMethod()]
[System.Web.Services.WebMethod]
public static List<string> SearchCustomers(string prefixText, int count)
{
    using (SqlConnection conn = new SqlConnection())
    {
        conn.ConnectionString = ConfigurationManager
                .ConnectionStrings["constr"].ConnectionString;
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = "select ContactName from Customers where " +
            "ContactName like @SearchText + '%'";
            cmd.Parameters.AddWithValue("@SearchText", prefixText);
            cmd.Connection = conn;
            conn.Open();
            List<string> customers = new List<string>();
            using (SqlDataReader sdr = cmd.ExecuteReader())
            {
                while (sdr.Read())
                {
                    customers.Add(sdr["ContactName"].ToString());
                }
            }
            conn.Close();
            return customers;
        }
    }
}

Screenshot

ASP.Net AJAX AutoCompleteExtender using database in ASP.Net Master Page example

ASP.Net AJAX Control Toolkit AutoCompleteExtender without using Web Services

Company

Explore

Follow us

Contact Us