Click here to Skip to main content
Licence 
First Posted 28 May 2005
Views 63,667
Bookmarked 36 times

Resizing Datagrid Columns to content, keeping the table styles

By | 28 May 2005 | Article
This simple function resizes all columns in a DataGrid to its contents, without losing table styles.

Introduction

In my quest to find an easy way to resize columns of a Datagrid object to its contents, I found an article right here at The Code Project by Tom Archer which should do just that. His code however erases all defined TableStyles that might have been added to the grid and makes a new one with recalculated widths of the ColumnStyles to fit the content. But all my grids have TableStyles (and ColumnStyles) defined, so this code didn't do it for me and my quest went on.

Solution

Ever tried to click just between two columns of a DataGrid? Right! The columns resize themselves to fit their content. Just the kind of behaviour I was looking for. So, why implement this behaviour, but not make this method public?

By extending the DataGrid class and adding a function to this extended class, I call the protected OnMouseDown method of the Datagrid class like this:

this.OnMouseDown(new MouseEventArgs(MouseButtons.Left, 2, x--, y, 0));

The parameter values I pass on to the MouseEventArgs constructor are:

  • the left mouse button is pressed,
  • twice (i.e., double click),
  • an x coordinate representing a coordinate right between two columns,
  • a y coordinate representing the coordinates of the column headers,
  • a zero Delta value (nudges of the mouse wheel, don't apply here for obvious reasons).

This call simulates a double click event at specific coordinates (namely between two columns headers).

Using the code

The complete code I wrote looks like this (this is an extension to the DataGrid class):

using System;
using System.Windows.Forms;

namespace Custom_Controls
{
    public class ExDataGrid: System.Windows.Forms.DataGrid
    {

        public void AutoResizeColumns()
        {
            //If the columnheaders aren't visible this code doesn't work...
            if( !this.ColumnHeadersVisible )
                return;

            //If there are no TableStyles defined, exit. Use Tom Archer's code.
            if(this.TableStyles.Count == 0)
                return;

            
            //This is the width of rowheaders 
            //(the part of the grid in front of each row)
            int x = this.RowHeaderWidth;
            int y = 2;
            //If the Caption is visible, the columnheaders 
            //are a bit below, so make y 23.
            if(this.CaptionVisible)
                y = 23;
            foreach(DataGridColumnStyle cstyle in 
                    this.TableStyles[0].GridColumnStyles)
            {
                //the y coordinate is already set, and doesn't change
                x += cstyle.Width + 1;
                //so adjust each time the x coordinate 
                //so the x,y coordinates represent a 
                //point between two columns
                
                //then fake a double click at that 
                //exact spot. -> the columns will resize.
                this.OnMouseDown(new MouseEventArgs(
                    MouseButtons.Left, 2, x--, y, 0));
            }
        }
    }
}

So to use this code, simply add an instance of the ExDataGrid (instead of the normal DataGrid) to your forms, and call this AutoResizeColumns() function.

Custom_Controls.ExDataGrid grid = new Custom_Controls.ExDataGrid();
grid.AutoResizeColumns();

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Tijz

Web Developer

Netherlands Netherlands

Member



Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
You must Sign In to use this message board. (secure sign-in)
 
Search this forum  
 FAQ
    Noise  Layout  Per page   
  Refresh
Generalaccessing the records through column Pinmemberkris_bgp0:40 3 Jul '06  
GeneralDo Not Works With Hidden Columns. Pinmembergeorani0:34 1 Jun '05  
GeneralRe: Do Not Works With Hidden Columns. PinsussAnonymous1:10 1 Jun '05  
GeneralAn alternative approach PinmemberRob Lans1:59 30 May '05  
GeneralRe: An alternative approach PinmemberTijz1:15 1 Jun '05  
GeneralRe: An alternative approach PinmemberTijz2:35 1 Jun '05  
GeneralRe: An alternative approach (Don't works too) Pinmembergeorani0:57 2 Jun '05  
GeneralRe: An alternative approach (Don't works too) PinmemberReinier Beeckman21:35 5 Jun '05  
GeneralRe: An alternative approach (Don't works too) Pinmemberqazwsxedc@mko.com18:32 6 Jun '05  
GeneralRe: An alternative approach (Don't works too) PinmemberSimon Soosai8:19 9 Jun '05  
GeneralRe: An alternative approach (Don't works too) Pinmembervrx419:36 11 Jun '05  
GeneralRe: An alternative approach (Don't works too) PinmemberHerbCSO2:15 24 Sep '05  

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Mobile
Web04 | 2.5.120517.1 | Last Updated 29 May 2005
Article Copyright 2005 by Tijz
Everything else Copyright © CodeProject, 1999-2012
Terms of Use
Layout: fixed | fluid