datagridview常用用法

DataGridView 控件用法合集

DataGridView控件用法合集

1.当前的单元格属性取得、变更

Console.WriteLine(DataGridView1.CurrentCell.Value)

Console.WriteLine(DataGridView1.CurrentCell.ColumnIndex)

Console.WriteLine(DataGridView1.CurrentCell.RowIndex)

DataGridView1.CurrentCell = DataGridView1(0, 0)

2.DataGridView编辑属性

全部单元格编辑属性

下例中 column2 的值是 True 的时候，Column1 设为可编辑

Private Sub DataGridView1_CellBeginEdit(ByVal sender As Object, _

ByVal e As DataGridViewCellCancelEventArgs) _

Handles DataGridView1.CellBeginEdit

Dim dgv As DataGridView = CType(sender, DataGridView)

If dgv.Columns(e.ColumnIndex).Name = "Column1" AndAlso _

Not CBool(dgv("Column2", e.RowIndex).Value) Then

e.Cancel = True

End If

End Sub

Console.WriteLine("現在のセルがある行は、新しい行ではありません。")

End If

DataGridView1.AllowUserToDeleteRows = False

根据条件判断当前行是否要删除

Private Sub DataGridView1_UserDeletingRow(ByVal sender As Object, _

DataGridView 控件用法合集

ByVal e As DataGridViewRowCancelEventArgs) _

Handles DataGridView1.UserDeletingRow

If MessageBox.Show("この列を削除しますか？", "削除の確認", _

MessageBoxButtons.OKCancel, MessageBoxIcon.Question) <> Windows.Forms.DialogResult.OK Then

DataGridView1.Rows(0).Visible = False

行列表头部分不表示

DataGridView1.ColumnHeadersVisible = False

DataGridView1.RowHeadersVisible = False

指定行列删除

DataGridView1.Columns.Remove("Column1")

DataGridView1.Columns.RemoveAt(0)

DataGridView1.Rows.RemoveAt(0)

选择的行列删除（多行列）

Dim r As DataGridViewRow

DataGridView1.AllowUserToResizeColumns = False

DataGridView1.AllowUserToResizeRows = False

指定行列宽度高度设置为不能编辑

DataGridView1.Columns(0).Resizable = DataGridViewTriState.False

DataGridView1.Rows(0).Resizable = DataGridViewTriState.False

列幅行高最小值设定

DataGridView1.Columns(0).MinimumWidth = 100

DataGridView1.Rows(0).MinimumHeight = 50

行列表头部分行高列幅设置为不能编辑

DataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing

DataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.EnableResizing

DataGridView 控件用法合集

DataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells

DataGridView1.Columns(0).AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells

列冻结（当前列以及左侧做所有列）

DataGridView1.Columns(1).Frozen = True

行冻结（当前行以及上部所有行）

DataGridView1.Rows(2).Frozen = True

指定单元格冻结（单元格所在行上部分所有行，列左侧所有列）

DataGridView1(0, 0). Frozen = True

DataGridView1.AllowUserToOrderColumns = True

DataGridView1.MultiSelect = False

单元格选择的时候默认为选择整行

DataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect

Console.WriteLine("選択されているセル")

For Each c As DataGridViewCell In DataGridView1.SelectedCells

Console.WriteLine("{0}, {1}", c.ColumnIndex, c.RowIndex)

Next c

Console.WriteLine("選択されている行")

For Each r As DataGridViewRow In DataGridView1.SelectedRows

DataGridView 控件用法合集

指定行、列、单元格取得

DataGridView1(0, 0).Selected = True

DataGridView1.Rows(1).Selected = True

If Not DataGridView1(0, 0).Displayed AndAlso _

DataGridView1(0, 0).Visible Then

DataGridView1.CurrentCell = DataGridView1(0, 0)

End If

DataGridView1.Columns(0).HeaderCell.Value = "はじめの列"

DataGridView1.Rows(0).HeaderCell.Value = "はじめの行"

DataGridView1.TopLeftHeaderCell.Value = "左上"

DataGridView1.Rows(i).HeaderCell.Value = i.ToString()

Next i

DataGridView1.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders)

最左上 Header 单元格文字列

DataGridView1.TopLeftHeaderCell.Value = "/"

拷贝模式设定

DataGridView1.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText

选中部分拷贝

Clipboard.SetDataObject(DataGridView1.GetClipboardContent())

Dim pasteText As String = Clipboard.GetText()

If String.IsNullOrEmpty(pasteText) Then

DataGridView 控件用法合集

Return

End If

pasteText = pasteText.Replace(vbCrLf, vbLf)

pasteText = pasteText.Replace(vbCr, vbLf)

Dim isHeader As Boolean = True

For Each line As String In lines

If isHeader Then

isHeader = False

Else

Dim vals As String() = line.Split(ControlChars.Tab)

If vals.Length - 1 <> DataGridView1.ColumnCount Then

Throw New ApplicationException("列数が違います。")