Problem in loading Data in Combobox

Question

0.00/5 (No votes)

See more:

Hi,

I have a combobox in my page . More than 20 thousand records will be selected and loaded into this combobox. While clicking this combobbox it's very slow to display the contents and takes more time to respond. How can i avoid this situation.

Thanks,
Velkumar.

Posted 16-Aug-12 0:53am

Velkumar Kannan

Add a Solution

Comments

Timberbird 16-Aug-12 7:12am

You mean you first force client's browser to download 20k records and then make user select one item from that huge list? Simply don't do that. You can split the list into different categories and first let user pick a category, or use any other workaround, but keeping that long list is just unacceptable

5 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)

I.explore.code · Answer 1 · 2012-08-16T01:09:00

1) Limit the number of elements shown in the combo box, otherwise it would defeat the usability of the control if the user has to browse through all that data to get to the item they want. For limiting data, you can try loading 5 items or 10 items at a time and when the user scrolls past the last one, you load the next set. Not sure how to do it, but definitely worth exploring.

2) Consider redesigning your app so instead of using a combo box perhaps use a GridView with paging.

3) Using UpdatePanel intelligently would make sure that this massive data doesn't always get reposted and hence doesn't bloat the view-state and therefore reduces the page size and the amount of HTML to render and hence becomes faster.

hope this helps.

Santhosh Kumar Jayaraman · Answer 2 · 2012-08-16T01:15:00

Why do you want to display 20000 records in Combobox?? Do you think user will be scrolling down and check 20000 records to select one record?

Try something else like autocomplete textbox or gridview with paging.

its very bad idea to load 20k records in a combobox.. Even if we make some changes still the performance will be an issue here always

**AmitGajjar** · Answer 3 · 2012-08-16T01:22:00

Hi,

You can add your custom control in your page. That custom control should have features like,

1) Paging for 10/20 records a page.
2) page should be navigate through Next/Previous/First/Last/Goto.
3) You need Searching in your custom Combobox.

Here[^] some basic idea about Custom control.

Hope this helps you

Thanks
-Amit Gajjar

kk2014 · Answer 4 · 2012-08-16T01:41:00

Solution 4

hi,

tell me one thing why should u bind these much amount of data in combo box?

thanks.

Posted 16-Aug-12 1:41am

kk2014

Ganesh Nikam · Answer 5 · 2012-08-16T02:26:00

Solution 5

hii,
instead of binding with combobox use autocomplete extender with textbox which will help user with limited amount of data

Posted 16-Aug-12 2:26am

Ganesh Nikam

Problem in loading Data in Combobox

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0