如何：以编程方式调整单元格的大小来适应 Windows 窗体 DataGridView 控件中的内容
更新：2007 年 11 月
可以使用 DataGridView 控件方法来调整行、列和标题的大小，以使行、列和标题的整个值以不截断方式显示。可以选择在任何时间使用这些方法来调整 DataGridView 元素的大小。或者，可以将控件配置为每当内容变更时就自动调整这些元素的大小。但是，当使用含有大量数据的数据集或数据频繁变更时，该方法可能效率很低。有关更多信息，请参见 Windows 窗体 DataGridView 控件中的大小调整选项。
通常，只有从数据源加载新数据或用户编辑了值时，才需以编程方式调整 DataGridView 元素以适应元素的内容。这种方式对优化性能十分有用，如果要允许用户以鼠标手动调整行和列的大小，也可使用这种方式。
下面的代码示例演示以编程方式调整大小时的可用选项。
示例
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
}
编译代码
此示例要求：
- 对 System、System.Drawing 和 System.Windows.Forms 程序集的引用。
有关从 Visual Basic 或 Visual C# 的命令行生成此示例的信息，请参见从命令行生成 (Visual Basic) 或在命令行上使用 csc.exe 生成。也可以通过将代码粘贴到新项目，在 Visual Studio 中生成此示例。如何：使用 Visual Studio 编译和运行完整的 Windows 窗体代码示例
如何：使用 Visual Studio 编译和运行完整的 Windows 窗体代码示例
如何：使用 Visual Studio 编译和运行完整的 Windows 窗体代码示例
如何：使用 Visual Studio 编译和运行完整的 Windows 窗体代码示例
如何：使用 Visual Studio 编译和运行完整的 Windows 窗体代码示例
请参见
任务
如何：自动调整单元格的大小来适应 Windows 窗体 DataGridView 控件中的内容变化
概念
Windows 窗体 DataGridView 控件中的大小调整选项
参考
DataGridView.AutoResizeColumns
DataGridView.AutoResizeColumnHeadersHeight
DataGridView.AutoResizeRowHeadersWidth
DataGridViewAutoSizeColumnMode
DataGridViewAutoSizeColumnsMode
DataGridViewColumnHeadersHeightSizeMode
DataGridViewRowHeadersWidthSizeMode