Click here to Skip to main content
Click here to Skip to main content

Resizing Datagrid Columns to content, keeping the table styles

, 28 May 2005
Rate this:
Please Sign up or sign in to vote.
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
No Biography provided

Comments and Discussions

 
Generalaccessing the records through column Pinmemberkris_bgp3-Jul-06 0:40 
GeneralDo Not Works With Hidden Columns. Pinmembergeorani1-Jun-05 0:34 
GeneralRe: Do Not Works With Hidden Columns. PinsussAnonymous1-Jun-05 1:10 
GeneralAn alternative approach PinmemberRob Lans30-May-05 1:59 
GeneralRe: An alternative approach PinmemberTijz1-Jun-05 1:15 
GeneralRe: An alternative approach PinmemberTijz1-Jun-05 2:35 
GeneralRe: An alternative approach (Don't works too) Pinmembergeorani2-Jun-05 0:57 
GeneralRe: An alternative approach (Don't works too) PinmemberReinier Beeckman5-Jun-05 21:35 
GeneralRe: An alternative approach (Don't works too) Pinmemberqazwsxedc@mko.com6-Jun-05 18:32 
GeneralRe: An alternative approach (Don't works too) PinmemberSimon Soosai9-Jun-05 8:19 
GeneralRe: An alternative approach (Don't works too) Pinmembervrx411-Jun-05 19:36 
GeneralRe: An alternative approach (Don't works too) PinmemberHerbCSO24-Sep-05 2:15 

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.

| Advertise | Privacy | Mobile
Web01 | 2.8.140721.1 | Last Updated 29 May 2005
Article Copyright 2005 by Tijz
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid