How to bind 70 000 record on editable dropdwon using jquery and ajax in ASP.NET

Question

1.00/5 (2 votes)

See more:

I am unable to bind more than 1000 record on editable dropdown while i need 70000 record to bind record on editable dropdown .
how to bind that large amount of data on editable dropdownList.

please help....
thanks in advance

What I have tried:

I am able to bind less than 1000 record on editable dropdwon .

Posted 20-Feb-19 23:50pm

Member 14157929

Updated 21-Feb-19 0:12am

Add a Solution

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)

F-ES Sitecore · Answer 1 · 2019-02-20T23:58:00

Solution 1

A dropdown is not suitable for that amount of data. Use a search\filter mechanism to reduce the number of items in your data set and maybe make a dropdown once you get them to a hundred or so, or use some other suitable display mechanism like a paged table.

Posted 20-Feb-19 23:58pm

F-ES Sitecore

Comments

Member 14157929 26-Feb-19 5:06am

because i need both key and value of data which we can find easily by dropdown.
if we use textbox for search then how to find both key and value form search box.

OriginalGriff · Answer 2 · 2019-02-21T00:12:00

Why do you think that dumping 70,000 records onto any type of control is a good solution? It's simple for you to do , but ... it's useless to the user because it'll be unbelievably slow - if it works at all, and it probably won't: it'll use memory like you wouldn't believe - and it will take them more time than they would wish to spare just to find the single entry they are looking for.

How long does it take to open a 70,000 item drop down list? How long does it take to scroll through it to the 69,997th item - which was the one the user wanted this time?

Just because you can do something, doesn't mean you should: I'd close the page and never visit your site again ...