Datagrid slow loading

Question

0.00/5 (No votes)

See more:

I have a Datagrid and there may be 1000 of rows in it. Based on a filter (combobox), Datagrid is filled with number of rows. So loading numbers of entries taking time till then my UI gets irresponsive.

My question is
1)Is 'Visibility' property stops the control to draw? If no then which property can be used?
2)Can you please suggest any approach to do that?

What I have tried:

I tried to use "Visibility" property for rows so that datagrid can show only visible those rows which are in visible client area. But this trick did not work.

Posted 25-Sep-20 5:31am

JM2251

Updated 26-Sep-20 22:59pm

Add a Solution

Comments

[no name] 25-Sep-20 12:51pm

Without seeing code, hard to suggest. Like drinking out of cup or sucking a straw; both work but with different efficiencies. And 1000 is not "a lot"; depends on how you go about it. The implication is that there are no "1000 row" Excel spreadsheets either even though the limit has never been less than 64,000 rows. And one doesn't scroll one row at a time with more than a few rows: one "pages".

3 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 · 2020-09-25T05:59:00

Basically, don't do it.

What do you expect the user to do with 1000 rows of data? How do you expect them to find the row they are interested in?

Don't just dump data on a user: it makes you app difficult to use and that means users won't use it - they will find an alternative that has a better design and use that instead.

Keep data to a minimum: that speeds display and makes the UI more approachable. Page data, filter it, search it: help the user to do their job, not dump data on them and expect them to do yours!

Dave Kreskowiak · Answer 2 · 2020-09-25T06:03:00

Visibility isn't really going to help you here.

Are you binding the grid to the data or are you adding each row of the dataset to the grid yourself? The later will take longer.

But, the major issue is you're adding a LOT of data to the grid. Having the user scroll through a thousand records is just go to piss users off. So you have to limit the data you're retrieving. Instead of returning as many rows as possible, change the database SELECT query to return the TOP 100 rows instead. You can let the user know the returned dataset is too large if you check the number of rows returned by the query and enable/disable such a UI notification to the user.

Perić Željko · Answer 3 · 2020-09-26T22:59:00

Solution 3

Try this link,
how to fill datagridview with thousand of records quickly ?[^]
where is also my solution of such problem.

All the best,
Željko Perić

Posted 26-Sep-20 22:59pm

Perić Željko

Comments

Richard MacCutchan 27-Sep-20 6:37am

It's still a very bad idea.

Datagrid slow loading

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0