what is the maximum elements in jquery auto complete script

Question

0.00/5 (No votes)

See more:

i use jquery auto complete in asp.net
i have problem when the array of autocomplete is more then 2000
but when it less than 2000 i doesn't have any problem
i use <%=sorce%> in the array of script and Get Values from database from behinde code
but when i it be larger the auto complete doesn't work

XML

        <pre lang="Javascript">
$(function () {
            var availableTags = [
            <%=sours%>
            ];
            $("#tags").autocomplete({
                source: availableTags
            });
        });

and this is my behind code

C#

SqlCommand cmd = new SqlCommand("Select الاسم From حلب", conAleppoM);
        if (conAleppoM.State.ToString() == "Closed") { conAleppoM.Open(); }
        SqlDataReader dr = cmd.ExecuteReader();
        int i = 0; 
        List<string> lst = new List<string>();
        while (dr.Read())
        {
            if (dr["الاسم"].ToString() != "" && dr["الاسم"].ToString() != "مجهول الهوية" && dr["الاسم"].ToString() != "مجهولة الهوية" && dr["الاسم"].ToString() != "مجهول الاسم" && dr["الاسم"].ToString() != "مجهول الكنية")
            {
                i++;
                lst.Add(dr["الاسم"].ToString());
            }
            //if (i == 1000) { break; }
        }
        dr.Close();
        conAleppoM.Close();
        bool bl = false;
        foreach (string str in lst)
        {
            if (!bl) { sours = "\"" + str + "\",\n"; bl = true; }
            else
            {
                if (!sours.Contains(str))
                {
                    sours = sours + "\"" + str + "\",\n";
                }
            }
            
        }

Posted 4-May-13 0:56am

Mallok96

Updated 4-May-13 1:17am

Sandeep Mewara

v3

Add a Solution

3 solutions

Add a Solution

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

PRAKASH9 · Answer 1 · 2013-05-04T03:20:00

Solution 1

use this in your web.config may be solved your problem

C#

<system.web.extensions>
    <scripting>
      <webservices>
        <jsonserialization maxjsonlength="2147483644" />
      </webservices>
    </scripting>
  </system.web.extensions>

Posted 4-May-13 3:20am

PRAKASH9

Updated 4-May-13 3:21am

v2

Comments

Mallok96 4-May-13 10:49am

it doesn't work
i have 10000 rows in my database when i break on 2000 it work

**Zoltán Zörgő** · Answer 2 · 2013-05-04T19:58:00

There are several thing I have noticed in your code:
- First of all, autocomplete is not for returning too many rows, since that has makes no sense. It is meant to be used by people, so a maximum of 15-20 elements is enough. While the user is typing, the list will refine content.
- You are currently filling up the autocomplete list in the html code (from code behind, but that's the same in this situation), so you have every element in the html which makes it static in some form. You should use the dynamic version, with an ajax callback to a ScriptService. Check this: http://jquery-with-asp.net/2011/07/jquery-ui-autocomplete-with-asp-net/[^]
- Use the text portion entered by the user (the parameter you get in the scriptservice method) to filter the returned list. All the conditions you added from code to get records with proper values - you can put in the select statement. You should put them there. And you should put a limitation to the fetched records by adding a TOP clause[^].
The query would look like this:

SQL

SELECT TOP 20 fieldname FROM table WHERE fieldname IS NOT NULL AND fieldname NOT IN ('value1','value2','value3','value4') AND الاسم LIKE @filter

(And do't forget to add wildcards to the @filter when passing the parameter value)

Mallok96 · Answer 3 · 2013-05-04T19:02:00

Solution 2

it doesn't work
i have 10000 rows in my database when i break on 2000 it work

Posted 4-May-13 19:02pm

Mallok96

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-May-13 1:22am

Why are you adding one answer as you have already commented inside the answer box ?
Please delete this.

what is the maximum elements in jquery auto complete script

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0

what is the maximum elements in jquery auto complete script

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us