Category / Section
How to validate changes made to a Grid cell in WinForms GridControl?
1 min read
Data validation
There are two events that can be used: CurrentCellValidating and CurrentCellValidated. The CurrentCellValidating is fired every time a key is pressed and the current text is passed as a part of the EventArgs. The CurrentCellValidated is only fired once when you try to leave the current cell.
The following code example illustrates how you can get the new value of the cell in the CurrentCellValidating event and how you can get the old value for either event.
C#
GridCurrentCell cc = this.gridControl1.CurrentCell; //Used in CurrentCellValidated event string newValue = cc.Renderer.ControlText; //used in CurrentCellVAlidatingEvent string oldValue = this.gridControl1[cc.RowIndex, cc.ColIndex].Text;
VB
Dim cc As GridCurrentCell = Me.gridControl1.CurrentCell ‘Used in CurrentCellValidated event Dim newValue As String = cc.Renderer.ControlText ‘Used in CurrentCellValidated event Dim oldValue As String = Me.gridControl1(cc.RowIndex, cc.ColIndex).Text
The following screenshot displays the cell value validated on editing using events and updated in TextBox.
Figure 1: Cell value validated on editing using events and updated in TextBox
Samples:
Reference link: https://help.syncfusion.com/windowsforms/grid-control/data-validation