How the datagridview will adjust its scroll bars so that all the columns and rows are shown in the form

Question

1.00/5 (1 vote)

See more:

i have a datagridview including 100 columns and 10,000 rows
now how will it fit into datagridview so that if scroll bars are dragged to extreme side
one could see all the figures . whether it's vertical scroll bar or horizontal scroll bar

What I have tried:

i am stuck in the regarding matter and could not go further. i have used
dgv.HorizontalScrollingOffset = dgv.Width;
but not very useful

Posted 15-Feb-21 23:14pm

Member 12712527

Updated 16-Feb-21 0:40am

v2

Add a Solution

Comments

Richard Deeming 16-Feb-21 5:24am

Do you seriously expect anyone to scroll through that many rows?

If your users could review one row per second, it would take them 2 hours and 47 minutes to review that much data.

Find a way to reduce the amount of data they have to view. Give them searching options, or summarize the data somehow.

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 · 2021-02-15T23:53:00

Don't even think about it. It's be incredibly slow to load, it's look like cack, and it'll be impossible for your users to use.

How long do you think it would take you to find the one row you are interested in out of 10,000? How far are they going to scroll 100 columns?
Answer: they won't. They'll take one look at your app, and uninstall it. Then demand their money back - I would.

Never preset a user with more than 100 rows at most: provide filters, searches, paging - just like google does when you search it: it says "I found 5,000,000 relevant item,s - here's the top 20", and when did you last even look at page 2, let alone 2000?

Just because it's simple for you to implement, doesn't mean it's the right thing to do!

RickZeeland · Answer 2 · 2021-02-16T00:39:00

Solution 2

In addition to the good advice offered by fellow CodeProjectors, make sure to:

Set Anchor property to: Top, Bottom, Left, Right
Set Scrollbars property to: Both

Also take a look at: Walkthrough: Implement virtual mode in DataGridView control - Windows Forms .NET Framework | Microsoft Docs[^]
And: c# - implementing virtual mode for a datagridview that is databound - Stack Overflow[^]
And: c# - Slow performance in populating DataGridView with large data - Stack Overflow[^]

Posted 16-Feb-21 0:39am

RickZeeland

Updated 16-Feb-21 2:51am

v3

Comments

Member 12712527 16-Feb-21 8:16am

not that but the dock property

RickZeeland 16-Feb-21 8:33am

Dock can sometimes be problematic, try to turn it off and use Anchor instead.

Member 12712527 17-Feb-21 2:54am

sir by using Anchor property the form becomes incredibly large which doesn't fit on the screen

RickZeeland 17-Feb-21 3:20am

That should not be the case, check if you did not set some other properties wrong.