Datagridview cell validating

I need to check that only one of the two can be checked. Its not permissible to have the two selected to true, but they can both be false. 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. If I then ckeck the second checbox (cell_2), it gives me the error message but does not return the second checkbox I checked to its unchecked state. Any help appreciated, Bob Once I'm in this process after the error text has been set, evn my close button, that has just a Me.close() in it does not work.

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. I'm going to revisit the sample mdb that I sent to the newsgroup, I still wonder why that did not work. NET doesn't use a short-circuiting AND operator by default and therefore CBool is used on other cells too. Its not permissible to have the two selected to true, but they can both be false. Error Text = "" Dim other Check As Boolean = False If (Datagrid1.

Its just that my UI does not respond correctly and I can't expect my users to get out of it that way. Bob "Bob" In a datagridview (vs2005, VB.net) I have two columns that are checkboxes.

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. What I realize now is the the e.cancel will prevent the cell from bieng changed or pushed to the unbderlying database but even when user changes cell back to what it should be or presses esc and cell comes bacj the error icon remains in the row selector. I,m going to make a really simple sample with a realy small Access database and post it here soon. 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[,].

If I then ckeck the second checbox (cell_2), it gives me the error message but does not return the second checkbox I checked to its unchecked state. Any help appreciated, Bob I tried to use the cellvalidating event on another column. I wrote code in the cellvalidating event as follows.

Leave a Reply