Increase the performance while loading data set with huge data to Combo Box in Win forms

Question

0.00/5 (No votes)

See more:

, +

Hi,

I am trying to bind a data set which has single column whose count is nearly 2lakhs. Now, when I tried to binding this datatable to Combo box its taking much time...more over my application is moving to "Not Reaponding State" for some time. Can any one suggest me to over come the issue.

Source Code:

this.ClassCodeComboBox.DisplayMember = classCodeDataTable.ClassCodeColumn.ColumnName;<br />
                    this.classCodeDataTable = this.form26000Control.WorkItem.F26000_ClassCodeDetails(parcelId).f26000ClassCode;<br />
<br />
                    if (classCodeDataTable.Rows.Count > 0)<br />
                    {<br />
                        this.ClassCodeComboBox.AutoCompleteMode = AutoCompleteMode.Suggest;<br />
                        this.ClassCodeComboBox.AutoCompleteSource = AutoCompleteSource.ListItems;<br />
                        this.ClassCodeComboBox.DataSource = classCodeDataTable;<br />
                        this.ClassCodeComboBox.Text = this.classCode;<br />
                        this.ClassCodeComboBox.Select(this.ClassCodeComboBox.Text.Length, 0);<br />
                    }

Win forms Application Frame work 3.5, Used Control:Combobox

Posted 13-Aug-14 4:36am

Purushotham Agaraharam

Add a Solution

Comments

[no name] 13-Aug-14 10:40am

You over come this issue but only loading a reasonable number of items. Do you really think that someone would want to scroll through whatever number 2lakhs is? I know it's a lot and no reasonable human being wants to read through all of that data.

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)

OriginalGriff · Answer 1 · 2014-08-13T04:44:00

The solution is simple: don't try to load any UI element with that many items.

Think about it: how you like to use that software and try to find the one selection you need to use in a list of 200,000 other ones? Every day? Probably several times every day?

If I tried that, my users would hate me, not use my software, and I wouldn't get paid.

Find a solution that lets them find what they need easier: filters, groups, whatever - but don't be so lazy! :laugh:

Nathan Minier · Answer 2 · 2014-08-13T04:53:00

I would crib from the jQuery autocomplete here and run a search on the server side for every x characters entered, for instance the autocomplete is inactive until 4 characters are entered, and then will populate with a filtered list. That way you have a filtered result coming in which will be substantially more refined and will not make your users rise up as a lynch mob.

This does mean that you'll need to add a service that will provide the filtered content and assign that as your data source. I'm afraid I can't tell you how best to do that off the top of my head in Web Forms, but I can tell you that in MVC it would be trivial.

Increase the performance while loading data set with huge data to Combo Box in Win forms

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0