Articles in this section
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.

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:

C#: ValidateChanges CS

VB: ValidateChanges VB

Reference link: https://help.syncfusion.com/windowsforms/grid-control/data-validation

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied