Cómo: Cambiar mediante programación el tamaño de las celdas para ajustar el contenido en el control DataGridView de formularios Windows Forms
Actualización: noviembre 2007
Puede utilizar los métodos del control DataGridView para cambiar el tamaño de las filas, columnas y encabezados para que muestren sus valores completos sin truncación. Estos métodos se utilizan para cambiar el tamaño de los elementos DataGridView de su elección. Otra opción es configurar el control para cambiar el tamaño de estos elementos automáticamente cada vez que cambia el contenido. Sin embargo, esta opción puede ser ineficaz cuando está trabajando con grandes conjuntos de datos o cuando los datos cambian con frecuencia. Para obtener más información, vea Opciones de ajuste de tamaño en el control DataGridView de formularios Windows Forms.
Normalmente, ajustará mediante programación los elementos DataGridView para que ajusten su contenido sólo cuando cargue nuevos datos de un origen de datos o cuando el usuario haya editado un valor. Resulta muy útil para optimizar el rendimiento, pero también es útil cuando se quiere permitir a los usuarios que cambien manualmente el tamaño de las filas y columnas con el mouse (ratón).
En el ejemplo de código siguiente se muestran las opciones disponibles para cambiar de tamaño mediante programación.
Ejemplo
Public Class ProgrammaticSizing
Inherits System.Windows.Forms.Form
#Region " form setup "
Public Sub New()
MyBase.New()
InitializeComponent()
AddDirections()
AddButton(Button1, "Reset")
AddButton(Button2, "Change Column 3 Header")
AddButton(Button3, "Change Meatloaf Recipe")
AddButton(Button10, "Change Restaurant 2")
AddButtonsForProgrammaticResizing()
End Sub
Friend WithEvents DataGridView1 As DataGridView
Friend WithEvents Button1 As Button = New Button()
Friend WithEvents Button2 As Button = New Button()
Friend WithEvents Button3 As Button = New Button()
Friend WithEvents Button4 As Button = New Button()
Friend WithEvents Button5 As Button = New Button()
Friend WithEvents Button6 As Button = New Button()
Friend WithEvents FlowLayoutPanel1 As FlowLayoutPanel
Friend WithEvents Button7 As Button = New Button()
Friend WithEvents Button8 As Button = New Button()
Friend WithEvents Button9 As Button = New Button()
Friend WithEvents Button10 As Button = New Button()
Friend WithEvents Button11 As Button = New Button()
Private Sub InitializeComponent()
Me.FlowLayoutPanel1 = New FlowLayoutPanel
Me.FlowLayoutPanel1.FlowDirection = FlowDirection.TopDown
Me.FlowLayoutPanel1.Location = New Point(454, 0)
Me.FlowLayoutPanel1.AutoSize = True
Me.AutoSize = True
Me.Text = Me.GetType().Name
Me.Controls.Add(FlowLayoutPanel1)
End Sub
Private Sub AddDirections()
Dim directions As New Label()
directions.AutoSize = True
Dim newLine As String = Environment.NewLine
directions.Text = "Press the buttons that start " & newLine _
& "with 'Change' to see how different sizing " & newLine _
& "modes deal with content changes."
FlowLayoutPanel1.Controls.Add(directions)
End Sub
Public Shared Sub Main()
Application.Run(New ProgrammaticSizing())
End Sub
#End Region
Private startingSize As Size
Private thirdColumnHeader As String = "Main Ingredients"
Private boringMeatloaf As String = "ground beef"
Private boringMeatloafRanking As String = "*"
Private boringRecipe As Boolean
Private shortMode As Boolean
Private otherRestaurant As String = "Gomes's Saharan Sushi"
Private Sub InitializeDataGridView(ByVal ignored As Object, _
ByVal ignoredToo As EventArgs) Handles Me.Load
Me.DataGridView1 = New System.Windows.Forms.DataGridView
Me.DataGridView1.Name = "DataGridView1"
Me.DataGridView1.Size = New System.Drawing.Size(292, 266)
Me.Controls.Add(Me.DataGridView1)
startingSize = New Size(450, 400)
DataGridView1.Size = startingSize
AddColumns()
PopulateRows()
shortMode = False
boringRecipe = True
End Sub
Private Sub AddColumns()
DataGridView1.ColumnCount = 4
DataGridView1.ColumnHeadersVisible = True
Dim columnHeaderStyle As New DataGridViewCellStyle
columnHeaderStyle.BackColor = Color.Aqua
columnHeaderStyle.Font = New Font("Verdana", 10, _
FontStyle.Bold)
DataGridView1.ColumnHeadersDefaultCellStyle = _
columnHeaderStyle
DataGridView1.Columns(0).Name = "Recipe"
DataGridView1.Columns(1).Name = "Category"
DataGridView1.Columns(2).Name = thirdColumnHeader
DataGridView1.Columns(3).Name = "Rating"
End Sub
Private Sub PopulateRows()
Dim row1 As String() = New String() _
{"Meatloaf", "Main Dish", boringMeatloaf, _
boringMeatloafRanking}
Dim row2 As String() = New String() _
{"Key Lime Pie", "Dessert", _
"lime juice, evaporated milk", _
"****"}
Dim row3 As String() = New String() _
{"Orange-Salsa Pork Chops", "Main Dish", _
"pork chops, salsa, orange juice", "****"}
Dim row4 As String() = New String() _
{"Black Bean and Rice Salad", "Salad", _
"black beans, brown rice", _
"****"}
Dim row5 As String() = New String() _
{"Chocolate Cheesecake", "Dessert", "cream cheese", _
"***"}
Dim row6 As String() = New String() _
{"Black Bean Dip", "Appetizer", _
"black beans, sour cream", "***"}
Dim rows As Object() = New Object() {row1, row2, row3, _
row4, row5, row6}
Dim rowArray As String()
For Each rowArray In rows
DataGridView1.Rows.Add(rowArray)
Next
For Each row As DataGridViewRow In DataGridView1.Rows
If row.IsNewRow Then Continue For
row.HeaderCell.Value = "Restaurant " & row.Index
Next
End Sub
Private Sub AddButton(ByVal button As Button, _
ByVal buttonLabel As String)
button.Text = buttonLabel
button.AutoSize = True
button.TabIndex = FlowLayoutPanel1.Controls.Count
FlowLayoutPanel1.Controls.Add(button)
End Sub
Private Sub ResetToDisorder(ByVal sender As Object, _
ByVal e As System.EventArgs) _
Handles Button1.Click
Controls.Remove(DataGridView1)
DataGridView1.Size = startingSize
DataGridView1.Dispose()
InitializeDataGridView(Nothing, Nothing)
End Sub
Private Sub ChangeColumn3Header(ByVal sender As Object, _
ByVal e As System.EventArgs) _
Handles Button2.Click
Toggle(shortMode)
If shortMode Then DataGridView1.Columns(2).HeaderText = "S" _
Else DataGridView1.Columns(2).HeaderText = thirdColumnHeader
End Sub
Private Shared Function Toggle(ByRef toggleThis As Boolean) _
As Boolean
toggleThis = Not toggleThis
End Function
Private Sub ChangeMeatloafRecipe(ByVal sender As Object, _
ByVal e As System.EventArgs) _
Handles Button3.Click
Toggle(boringRecipe)
If boringRecipe Then
SetMeatloaf(boringMeatloaf, boringMeatloafRanking)
Else
Dim greatMeatloafRecipe As String = "1 lb. lean ground beef, " _
& "1/2 cup bread crumbs, 1/4 cup ketchup," _
& "1/3 tsp onion powder, " _
& "1 clove of garlic, 1/2 pack onion soup mix " _
& " dash of your favorite BBQ Sauce"
SetMeatloaf(greatMeatloafRecipe, "***")
End If
End Sub
Private Sub SetMeatloaf(ByVal recipe As String, _
ByVal rating As String)
DataGridView1.Rows(0).Cells(2).Value = recipe
DataGridView1.Rows(0).Cells(3).Value = rating
End Sub
Private Sub ChangeRestaurant(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Button10.Click
If DataGridView1.Rows(2).HeaderCell.Value.Equals(otherRestaurant) Then
DataGridView1.Rows(2).HeaderCell.Value = _
"Restaurant 2"
Else
DataGridView1.Rows(2).HeaderCell.Value = _
otherRestaurant
End If
End Sub
#Region "programmatic resizing"
Private Sub AddButtonsForProgrammaticResizing()
AddButton(Button4, "Size Third Column")
AddButton(Button5, "Size Column Headers")
AddButton(Button6, "Size All Columns")
AddButton(Button7, "Size Third Row")
AddButton(Button8, "Size First Row Header Using All Headers")
AddButton(Button9, "Size All Rows and Row Headers")
AddButton(Button11, "Size All Rows")
End Sub
' The following code example resizes the second column to fit.
Private Sub SizeThirdColumnHeader(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Button4.Click
DataGridView1.AutoResizeColumn( _
2, DataGridViewAutoSizeColumnMode.ColumnHeader)
End Sub
' The following code example resizes the second column to fit
' the header
' text, but it leaves the widths of the
' row headers and columns unchanged.
Private Sub SizeColumnHeaders(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Button5.Click
DataGridView1.AutoResizeColumnHeadersHeight(2)
End Sub
' The following code example resizes all the columns to fit the
' header text and column contents.
Private Sub SizeAllColumns(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Button6.Click
DataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells)
End Sub
' The following code example resizes the third row
' to fit the column contents.
Private Sub SizeThirdRow(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Button7.Click
Dim thirdRow As Integer = 2
DataGridView1.AutoResizeRow( _
2, DataGridViewAutoSizeRowMode.AllCellsExceptHeader)
End Sub
' The following code example resizes the first displayed row
' to fit it's header.
Private Sub SizeFirstRowHeaderToAllHeaders(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Button8.Click
DataGridView1.AutoResizeRowHeadersWidth( _
DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders)
End Sub
' Size all the rows, including their headers and columns.
Private Sub SizeAllRowsAndTheirHeaders(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Button9.Click
DataGridView1.AutoResizeRows(DataGridViewAutoSizeRowsMode.AllCells)
End Sub
Private Sub SizeAllRows(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Button11.Click
DataGridView1.AutoResizeRows(DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders)
End Sub
#End Region
End Class
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
public class ProgrammaticSizing : System.Windows.Forms.Form
{
private FlowLayoutPanel flowLayoutPanel1;
private Button button1 = new Button();
private Button button2 = new Button();
private Button button3 = new Button();
private Button button4 = new Button();
private Button button5 = new Button();
private Button button6 = new Button();
private Button button7 = new Button();
private Button button8 = new Button();
private Button button9 = new Button();
private Button button10 = new Button();
private Button button11 = new Button();
public ProgrammaticSizing()
{
InitializeComponent();
AddDirections();
this.Load += new EventHandler(InitializeDataGridView);
AddButton(button1, "Reset",
new EventHandler(ResetToDisorder));
AddButton(button2, "Change Column 3 Header",
new EventHandler(ChangeColumn3Header));
AddButton(button3, "Change Meatloaf Recipe",
new EventHandler(ChangeMeatloafRecipe));
AddButton(button10, "Change Restaurant 2",
new EventHandler(ChangeRestaurant));
AddButtonsForProgrammaticResizing();
}
#region form code
private void InitializeComponent()
{
this.flowLayoutPanel1 = new FlowLayoutPanel();
this.flowLayoutPanel1.FlowDirection
= FlowDirection.TopDown;
this.flowLayoutPanel1.Location = new Point(492, 0);
this.flowLayoutPanel1.AutoSize = true;
this.AutoSize = true;
this.Controls.Add(this.flowLayoutPanel1);
this.Text = this.GetType().Name;
}
private void AddDirections()
{
Label directions = new Label();
directions.AutoSize = true;
String newLine = Environment.NewLine;
directions.Text = "Press the buttons that start " + newLine
+ "with 'Change' to see how different sizing " + newLine
+ "modes deal with content changes.";
flowLayoutPanel1.Controls.Add(directions);
}
#endregion
[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.Run(new ProgrammaticSizing());
}
private Size startingSize;
private string thirdColumnHeader = "Main Ingredients";
private string boringMeatloaf = "ground beef";
private string boringMeatloafRanking = "*";
private bool boringRecipe;
private bool shortMode;
private DataGridView dataGridView1;
private string otherRestaurant = "Gomes's Saharan Sushi";
private void InitializeDataGridView(Object sender,
EventArgs ignoredToo)
{
this.dataGridView1 = new DataGridView();
this.dataGridView1.Location = new Point(0, 0);
this.dataGridView1.Size = new Size(292, 266);
this.Controls.Add(this.dataGridView1);
startingSize = new Size(450, 400);
dataGridView1.Size = startingSize;
AddColumns();
PopulateRows();
shortMode = false;
boringRecipe = true;
}
private void AddColumns()
{
dataGridView1.ColumnCount = 4;
dataGridView1.ColumnHeadersVisible = true;
DataGridViewCellStyle columnHeaderStyle =
new DataGridViewCellStyle();
columnHeaderStyle.BackColor = Color.Aqua;
columnHeaderStyle.Font = new Font("Verdana", 10,
FontStyle.Bold);
dataGridView1.ColumnHeadersDefaultCellStyle =
columnHeaderStyle;
dataGridView1.Columns[0].Name = "Recipe";
dataGridView1.Columns[1].Name = "Category";
dataGridView1.Columns[2].Name = thirdColumnHeader;
dataGridView1.Columns[3].Name = "Rating";
}
private void PopulateRows()
{
string[] row1 = {
"Meatloaf", "Main Dish",
boringMeatloaf, boringMeatloafRanking
};
string[] row2 = {
"Key Lime Pie", "Dessert",
"lime juice, evaporated milk", "****"
};
string[] row3 = {
"Orange-Salsa Pork Chops", "Main Dish",
"pork chops, salsa, orange juice", "****"
};
string[] row4 = {
"Black Bean and Rice Salad", "Salad",
"black beans, brown rice", "****"
};
string[] row5 = {
"Chocolate Cheesecake", "Dessert",
"cream cheese", "***"
};
string[] row6 = {
"Black Bean Dip",
"Appetizer", "black beans, sour cream", "***"
};
object[] rows = new object[] {
row1, row2, row3, row4, row5, row6
};
foreach (string[] row in rows)
dataGridView1.Rows.Add(row);
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.IsNewRow) break;
row.HeaderCell.Value = "Restaurant " + row.Index;
}
}
private void AddButton(Button button, string buttonLabel,
EventHandler handler)
{
button.Text = buttonLabel;
button.AutoSize = true;
flowLayoutPanel1.Controls.Add(button);
button.Click += handler;
}
private void ResetToDisorder(Object sender, EventArgs e)
{
Controls.Remove(dataGridView1);
dataGridView1.Size = startingSize;
dataGridView1.Dispose();
InitializeDataGridView(null, null);
}
private void ChangeColumn3Header(Object sender, EventArgs e)
{
Toggle(ref shortMode);
if (shortMode)
dataGridView1.Columns[2].HeaderText = "S";
else
dataGridView1.Columns[2].HeaderText =
thirdColumnHeader;
}
private static void Toggle(ref Boolean toggleThis)
{
toggleThis = !toggleThis;
}
private void ChangeMeatloafRecipe(Object sender,
EventArgs e)
{
Toggle(ref boringRecipe);
if (boringRecipe)
SetMeatloaf(boringMeatloaf, boringMeatloafRanking);
else
{
string greatMeatloafRecipe =
"1 lb. lean ground beef, "
+ "1/2 cup bread crumbs, 1/4 cup ketchup,"
+ "1/3 tsp onion powder, "
+ "1 clove of garlic, 1/2 pack onion soup mix "
+ " dash of your favorite BBQ Sauce";
SetMeatloaf(greatMeatloafRecipe, "***");
}
}
private void SetMeatloaf(string recipe, string rating)
{
dataGridView1.Rows[0].Cells[2].Value = recipe;
dataGridView1.Rows[0].Cells[3].Value = rating;
}
private void ChangeRestaurant(Object sender,
EventArgs ignored)
{
if (dataGridView1.Rows[2].HeaderCell.Value.Equals(otherRestaurant))
{
dataGridView1.Rows[2].HeaderCell.Value =
"Restaurant 2";
}
else
{
dataGridView1.Rows[2].HeaderCell.Value = otherRestaurant;
}
}
#region "programmatic resizing"
private void AddButtonsForProgrammaticResizing()
{
AddButton(button4, "Size Third Column",
new EventHandler(SizeThirdColumnHeader));
AddButton(button5, "Size Column Headers",
new EventHandler(SizeColumnHeaders));
AddButton(button6, "Size All Columns",
new EventHandler(SizeAllColumns));
AddButton(button7, "Size Third Row",
new EventHandler(SizeThirdRow));
AddButton(button8, "Size First Row Header Using All Headers",
new EventHandler(SizeFirstRowHeaderToAllHeaders));
AddButton(button9, "Size All Rows and Row Headers",
new EventHandler(SizeAllRowsAndTheirHeaders));
AddButton(button11, "Size All Rows ",
new EventHandler(SizeAllRows));
}
private void SizeThirdColumnHeader(Object sender,
EventArgs e)
{
dataGridView1.AutoResizeColumn(
2, DataGridViewAutoSizeColumnMode.ColumnHeader);
}
private void SizeColumnHeaders(Object sender, EventArgs e)
{
dataGridView1.AutoResizeColumnHeadersHeight(2);
}
private void SizeAllColumns(Object sender, EventArgs e)
{
dataGridView1.AutoResizeColumns(
DataGridViewAutoSizeColumnsMode.AllCells);
}
private void SizeThirdRow(Object sender, EventArgs e)
{
dataGridView1.AutoResizeRow(
2, DataGridViewAutoSizeRowMode.AllCellsExceptHeader);
}
private void SizeFirstRowHeaderToAllHeaders(Object sender, EventArgs e)
{
dataGridView1.AutoResizeRowHeadersWidth(
0, DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
}
private void SizeAllRowsAndTheirHeaders(Object sender, EventArgs e)
{
dataGridView1.AutoResizeRows(
DataGridViewAutoSizeRowsMode.AllCells);
}
private void SizeAllRows(Object sender,
EventArgs e)
{
dataGridView1.AutoResizeRows(
DataGridViewAutoSizeRowsMode.AllCellsExceptHeaders);
}
#endregion
}
Compilar el código
Para este ejemplo se necesita:
- Referencias a los ensamblados System, System.Drawing y System.Windows.Forms.
Para obtener información sobre la generación de este ejemplo desde la línea de comandos de Visual Basic o Visual C#, vea Generar desde la línea de comandos (Visual Basic) o Generar la línea de comandos con csc.exe. También puede generar este ejemplo en Visual Studio pegando el código en un proyecto nuevo.
Vea también
Tareas
Conceptos
Opciones de ajuste de tamaño en el control DataGridView de formularios Windows Forms
Referencia
DataGridView.AutoResizeColumns
DataGridView.AutoResizeColumnHeadersHeight
DataGridView.AutoResizeRowHeadersWidth
DataGridViewAutoSizeColumnMode
DataGridViewAutoSizeColumnsMode
DataGridViewColumnHeadersHeightSizeMode
DataGridViewRowHeadersWidthSizeMode
Otros recursos
Cambiar el tamaño de columnas y filas en el control DataGridView de formularios Windows Forms