Category / Section
What is the use of the GetCells and SetCells methods in WinForms GridControl?
1 min read
GetCells and SetCells method
The GetCells method gets a table, like GridStyleInfoStoreTable, that represents a range of cells when GridRangeInfo is specified. A GridStyleInfoStoreTable object holds the contents for all the cells.
The SetCells changes the contents for a range of cells in one batch, that is, when it is given a target, like GridRangeInfo and a table that holds the contents of the cells, like GridStyleInfoStoreTable, it sets the target with the table's value along with all the cell’s Style properties.
C#
int colCount = this.gridControl1.ColCount; GridRangeInfo source = GridRangeInfo.Cells(top, 1, bottom, colCount); GridRangeInfo target = GridRangeInfo.Cells(top + 4, 1, bottom + 4, colCount); GridStyleInfoStoreTable cells = this.gridControl1.GetCells(source); this.gridControl1.BeginUpdate(); this.gridControl1.SetCells(target, cells); //this.gridControl1.Rows.InsertRange(4, 4); this.gridControl1.EndUpdate(false); this.gridControl1.Refresh();
VB
Dim colCount As Integer = Me.gridControl1.ColCount Dim source As GridRangeInfo = GridRangeInfo.Cells(top, 1, bottom, colCount) Dim target As GridRangeInfo = GridRangeInfo.Cells(top + 4, 1, bottom + 4, colCount) Dim cells As GridStyleInfoStoreTable = Me.gridControl1.GetCells(source) Me.gridControl1.BeginUpdate() Me.gridControl1.SetCells(target, cells) 'this.gridControl1.Rows.InsertRange(4, 4); Me.gridControl1.EndUpdate(False) Me.gridControl1.Refresh()
Samples: