I recommend setting the Cancel property to true for invalid data as then the user focus will remain in cell 2. (inside your column test) events are used to help stop the user from leaving a cell with a bad value.I recommend setting the Cancel property to true for invalid data as then the user focus will remain in cell 2. (inside your column test) hey thankxx but the thing is i have to click on another place in the datagrid view to trigger the event.
provides a convenient way to realize data validation before it is committed to the underlying data source.
SOLUTION To achieve data validation prior the row is committed, you can handle the Cell Validating event, which is raised by the control when the current cell changes or when it goes out of edit mode.
Canceling this event prevents the user from exiting the cell until a valid value is entered or the edit process is canceled (via Esc key).
The Data Bound Item will be updated only if the cell is validated.
At this point the user is not allowed to cancel the performed changes, pressing the Esc key.
hi there, this question have posted before also, but i ahave some more questions as well.However, the user may prefer to validate all the data cells in a row at once.This scenario can be achieved by using the Row Validating event, which is fired when the user tries to change the current row (changing to another row or when the control loses focus).Note that only the Cell Validating event can keep the editor active,when the validation fails and it does not allow the user to exit the cell until a valid value is filled.However, pressing the Esc key in this situation will revert the initial value of the cell and it will close the editor. The Row Validating event has a slightly different behavior.What you have to do instead is change the value in the editing control (remembering not to cancel the event).