方法 : 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 で新しいプロジェクトにコードを貼り付けてこの例をビルドすることもできます。方法 : 完成した Windows フォーム コードの例を Visual Studio を使ってコンパイルして実行する
方法 : 完成した Windows フォーム コードの例を Visual Studio を使ってコンパイルして実行する
方法 : 完成した Windows フォーム コードの例を Visual Studio を使ってコンパイルして実行する
方法 : 完成した Windows フォーム コードの例を Visual Studio を使ってコンパイルして実行する
方法 : 完成した Windows フォーム コードの例を Visual Studio を使ってコンパイルして実行する
参照
処理手順
方法 : Windows フォームの DataGridView コントロールの内容変更時にセルのサイズを自動的に変更する
概念
Windows フォーム DataGridView コントロールのサイズ変更オプション
参照
DataGridView.AutoResizeColumns
DataGridView.AutoResizeColumnHeadersHeight
DataGridView.AutoResizeRowHeadersWidth
DataGridViewAutoSizeColumnMode
DataGridViewAutoSizeColumnsMode
DataGridViewColumnHeadersHeightSizeMode
DataGridViewRowHeadersWidthSizeMode