Programmatically resize DataGridView to remove scroll bars.

Question

4.33/5 (3 votes)

See more:

I have a DataGridView with a user definable number of columns (anywhere from ~6-60) of numerical data. At the higher end that amount of data in the grid exceeds that which can be displayed on screen at once. I have a graph that goes with the data. I would like to keep the two in sync, so that a specific time T on the graph is in line vertically with the same time in the grid.

To do this I'd like to make the DataGridView just wide enough to avoid a scroll bar, have the graph be equally wide, and then offload the scrolling onto a container control. However, I can't find a way to directly get the width I'd need to set the DataGridView to in order to remove the scroll bar from it.

Posted 11-Jul-11 4:16am

Dan Neely

Updated 11-Jul-11 9:19am

Chris Maunder772.8K

v2

Add a Solution

Comments

wizardzz 11-Jul-11 10:27am

Good question, I've never had to do this but I'm curious how.

wizardzz 11-Jul-11 16:25pm

Are the dynamically added columns of a fixed width? Could you force them to be?

Dan Neely 11-Jul-11 17:01pm

They are fixed width.

wizardzz 11-Jul-11 17:07pm

Is it possibly to just calculate numbers of columns by the fixed widths + a fixed buffer? Obviously I'm not sure if this would work so I'm putting it as a comment, not solution. I think I may have hacked something like that together in the past.

2 solutions

Solution 1

Seems like, you can have your chart and DataGridView fixed sized, and just use the AutoSizeColumnMode to fit the columns in view without scrollbar.
http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.autosizecolumnsmode.aspx[^]

Posted 11-Jul-11 20:10pm

Prerak Patel

Comments

Dan Neely 12-Jul-11 8:42am

That's not a suitable option. At the high end a scroll bar is needed to give enough space to allow the columns to be big enough to show the numbers. At the low end having 6 2" wide columns that are 90% empty and of which only 3 are visible isn't acceptable either.

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)

Dan Neely · Accepted Answer · 2011-07-13T03:55:00

Wizardzz was on the right track; I got this from another site:

/// <summary>
/// Return the minimum width in pixels a DataGridView can be before the control's vertical scrollbar would be displayed.
/// </summary>
private int GetDataGridViewMinWidth(DataGridView dataGridView) {
    // Add two pixels for the border for BorderStyles other than None.
    var controlBorderWidth = (dataGridView.BorderStyle == BorderStyle.None) ? 0 : 2;

    // Return the width of all columns plus the row header, and adjusted for the DataGridView's BorderStyle.
    return dataGridView.Columns.GetColumnsWidth(DataGridViewElementStates.Visible) + dataGridView.RowHeadersWidth + controlBorderWidth;
}