When I reopen it I can see that the chages were not comitted to the database, which is fine.
I noticed that when I click on the checkbox to uncheck it after the e.cancel executed, that click does not change its value, I can both see in the UI that the value did not change before the cellvalidating event is called and in the cellvalidating event itself, when I set a breakpoint after the line that checks and verify the value of CBool(Datagrid1("Cell_2", e. The only way to close the form is to click on the form close cross in the upper right corner of the form.
Data Property Name = "Cell_2") Then If CBool(Datagrid1("Cell_1", e. I wrote code in the cellvalidating event as follows. Data Grid View Cell Validating Eve nt Args) Handles Datagrid1.
Its not permissible to have the two selected to true, but they can both be false.
Data Property Name = "Cell_2") Then If CBool(Datagrid1("Cell_1", e. Private Sub Datagrid1_Cell Validating(By Val sender As Object, By Val e As System.
Value" for both Check Box, only for the non-editing Check Box, for the the editing Check Box you need to use e. (Note, Formatted Value is either a Boolean (Three State=false) or a Check State (Three State=true). Data Grid View Cell Validating Eve nt Args) Handles Datagrid1.
I think common behaviour is so that the user can't leave the cell once validation fails and is forced to correct it before he can leave the cell. But there is a problem in your code, you can't use "Data Grid View[,].