Ajax Autocomplete extender textbox

Question

0.00/5 (No votes)

See more:

Hello everyone,
I am struck with a unique problem. I have 1 usercontrol where I am this auto suggest extender. I am using this control on all the pages where ever I need autosuggest testbox but on 1 page its not working. I have registered the control on the page still its not working, can someone suggest me something?

XML

I am just calling the control on the page where i need this auto suggest textbox like this :
<uc1:ctrlFetchemps ID="ctrlFetchemps1" runat="server" />
I have registered it on the page like this :
  <%@ Register Src="~/WebUserControls/Common/ctrlFetchemps .ascx" TagName="ctrlFetchemps " TagPrefix="uc1" %>

Posted 11-Sep-13 1:07am

praveen sethiya

Updated 11-Sep-13 1:31am

v2

Add a Solution

Comments

Salman622 11-Sep-13 7:19am

check out the sql query in your function

praveen sethiya 11-Sep-13 7:23am

Thanks for the reply but I think I am just calling the control on the page, if its sql query who is at fault then this should have not worked from anywhere but this autosuggest is working fine from other pages. Please correct me if am wrong somewhere. Never used this auto suggest extender.

ZurdoDev 11-Sep-13 7:22am

You'll need to post relevant code and what is different about the one page?

praveen sethiya 11-Sep-13 7:31am

I am just calling the control on the page where i need this auto suggest textbox like this :
<uc1:ctrlFetchemps ID="ctrlFetchemps1" runat="server" />
I have registered it on the page like this :
<%@ Register Src="~/UserCtls/Common/ctrlFetchemps .ascx" TagName="ctrlFetchemps " TagPrefix="uc1" %>

ZurdoDev 11-Sep-13 8:01am

Yes, but something about the page is different otherwise it would work too.

TrushnaK 11-Sep-13 7:43am

are you sure about this path "~/UserCtls/Common/ctrlFetchemps .ascx"
because you have given "~/WebUserControls/Common/ctrlFetchemps .ascx" this path above in your example.

praveen sethiya 12-Sep-13 3:56am

Oh its a typo.
I have checked it.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

praveen sethiya · Answer 1 · 2013-09-12T00:55:00

Solution 2

Thanks guys for replying though I have solved it myself. There was a javascript missing for the same. Thanks once again.

Posted 12-Sep-13 0:55am

praveen sethiya

Salman622 · Answer 2 · 2013-09-11T01:27:00

try this in your aspx page

XML

<asp:TextBox ID="Item_Name" runat="server" Width="200px"
            ontextchanged="Item_Name_TextChanged" AutoPostBack="True" TabIndex="2"></asp:TextBox>
        <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" CompletionInterval="500" MinimumPrefixLength="1" ServiceMethod="Getdata"
                        TargetControlID="Item_Name" UseContextKey="True">
        </asp:AutoCompleteExtender>

and in .cs do as below

C#

[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
        public static string[] Getdata(string prefixText, int count, string contextKey)
        {
            SqlConnection con1 = new SqlConnection(Connection.getConnectionString());
            con1.Open();

            DataTable dt = new DataTable();
            SqlCommand cmd = new SqlCommand();
            SqlDataAdapter adap = new SqlDataAdapter("Your sql query for suggesstion, con1);
            adap.Fill(dt);

            string[] main = new string[0];
            int j = dt.Rows.Count; //ds.Tables["Ledger_Master"].Rows.Count;

            for (int i = 0; i < j; i++)
            {
                //if (ds.Tables[0].Rows[i].ItemArray[0].ToString().ToLower().StartsWith(prefixText.ToLower()))
                if (dt.Rows[i].ItemArray[0].ToString().ToLower().Contains(prefixText.ToLower()))
                {
                    Array.Resize(ref main, main.Length + 1);
                    //main[main.Length - 1] = ds.Tables[0].Rows[i].ItemArray[0].ToString();
                    main[main.Length - 1] = dt.Rows[i].ItemArray[0].ToString();
                    if (main.Length == 15)
                        break;
                }
            } con1.Close();
            Array.Sort(main);
            return main;
        }