|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Cell validating event problem.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 wrote code in the cellvalidating event as follows. Private Sub Datagrid1_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles Datagrid1.CellValidating Me.Datagrid1.Rows(e.RowIndex).ErrorText = "" If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_1") Or _ (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_2") Then If CBool(Datagrid1("Cell_1", e.RowIndex).Value) = True _ And CBool(Datagrid1("Cell_2", e.RowIndex).Value) = True Then Me.Datagrid1.Rows(e.RowIndex).ErrorText = "Can't have both values true." e.Cancel = True End If End If End Sub Say I checked just one checkbox Cell_1 to start, the code allows the change to be made. 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. 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.RowIndex).Value) it remains set to true. What am I doing wrong? I press the sacep key after the e,cancel and the message and I get the same problem. 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. The only way to close the form is to click on the form close cross in the upper right corner of the form. When I reopen it I can see that the chages were not comitted to the database, which is fine. Its just that my UI does not respond correctly and I can't expect my users to get out of it that way. Any help would be appreciated. Bob Show quoteHide quote "Bob" <bduf***@sgiims.com> wrote in message news:%23zS3s1UFGHA.3856@TK2MSFTNGP12.phx.gbl... > In a datagridview (vs2005, VB.net) I have two columns that are checkboxes. > 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 wrote code in the cellvalidating event as follows. > Private Sub Datagrid1_CellValidating(ByVal sender As Object, ByVal e As > System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles > Datagrid1.CellValidating > > Me.Datagrid1.Rows(e.RowIndex).ErrorText = "" > > If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_1") Or _ > > (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_2") Then > > If CBool(Datagrid1("Cell_1", e.RowIndex).Value) = True _ > > And CBool(Datagrid1("Cell_2", e.RowIndex).Value) = True Then > > Me.Datagrid1.Rows(e.RowIndex).ErrorText = "Can't have both values true." > > e.Cancel = True > > End If > > End If > > End Sub > > Say I checked just one checkbox Cell_1 to start, the code allows the > change to be made. 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. 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.RowIndex).Value) it remains set to true. > > > > What am I doing wrong? I press the sacep key after the e,cancel and the > message and I get the same problem. > > Any help appreciated, > > Bob > > > > > > > > I tried to use the cellvalidating event on another column. 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. You can't change row you're stuck. I,m going to make a really simple sample with a realy small Access database and post it here soon. Bob Show quoteHide quote "Bob" <bduf***@sgiims.com> wrote in message news:O2WlaMVFGHA.752@TK2MSFTNGP12.phx.gbl... > 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. The only way to > close the form is to click on the form close > cross in the upper right corner of the form. When I reopen it I can see > that the chages were not comitted to the database, which is fine. Its just > that my UI does not respond correctly and I can't expect my users to get > out of it that way. > > Any help would be appreciated. > > Bob > > "Bob" <bduf***@sgiims.com> wrote in message > news:%23zS3s1UFGHA.3856@TK2MSFTNGP12.phx.gbl... >> In a datagridview (vs2005, VB.net) I have two columns that are >> checkboxes. 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 wrote code in the cellvalidating event as follows. >> Private Sub Datagrid1_CellValidating(ByVal sender As Object, ByVal e As >> System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles >> Datagrid1.CellValidating >> >> Me.Datagrid1.Rows(e.RowIndex).ErrorText = "" >> >> If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_1") Or _ >> >> (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_2") Then >> >> If CBool(Datagrid1("Cell_1", e.RowIndex).Value) = True _ >> >> And CBool(Datagrid1("Cell_2", e.RowIndex).Value) = True Then >> >> Me.Datagrid1.Rows(e.RowIndex).ErrorText = "Can't have both values true." >> >> e.Cancel = True >> >> End If >> >> End If >> >> End Sub >> >> Say I checked just one checkbox Cell_1 to start, the code allows the >> change to be made. 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. 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.RowIndex).Value) it remains set to true. >> >> >> >> What am I doing wrong? I press the sacep key after the e,cancel and the >> message and I get the same problem. >> >> Any help appreciated, >> >> Bob >> >> >> >> >> >> >> >> > > Hi,
"Bob" <bduf***@sgiims.com> wrote in message I think common behaviour is so that the user can't leave the cell once news:%23zS3s1UFGHA.3856@TK2MSFTNGP12.phx.gbl... > In a datagridview (vs2005, VB.net) I have two columns that are checkboxes. > 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 wrote code in the cellvalidating event as follows. validation fails and is forced to correct it before he can leave the cell. You can use the esc key to revert the value. But there is a problem in your code, you can't use "DataGridView[,].Value" for both CheckBox, only for the non-editing CheckBox, for the the editing CheckBox you need to use e.FormattedValue. (Note, FormattedValue is either a Boolean (ThreeState=false) or a CheckState (ThreeState=true). Private Sub Datagrid1_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles Datagrid1.CellValidating Me.Datagrid1.Rows(e.RowIndex).ErrorText = "" Dim otherCheck As Boolean = False If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_1") Then otherCheck = CBool(Datagrid1("Cell_2", e.RowIndex).Value) End If If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_2") Then otherCheck = CBool(Datagrid1("Cell_1", e.RowIndex).Value) End If If ( otherCheck And CBool(e.FormattedValue) ) Then Me.Datagrid1.Rows(e.RowIndex).ErrorText = "Can't have both values true." e.Cancel = True End If End Sub HTH, Greetings Show quoteHide quote > > End If > > End Sub > > Say I checked just one checkbox Cell_1 to start, the code allows the > change to be made. 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. 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.RowIndex).Value) it remains set to true. > > > > What am I doing wrong? I press the sacep key after the e,cancel and the > message and I get the same problem. > > Any help appreciated, > > Bob > > > > > > > > Thanks Bart I will definitely look at the code, but I think there's a deeper
problem here or bad documentation. I zipped a little sample folder with a small app that contains an mdb with a small table, (I only took the contents of the folder that had the basic forms and Mdb in it wanting to keep the attachment samall) The table only has two fields. I cut and pasted the code from the microsoft sample about the event, only just changing the datagridview name since by default I got another name than the sample. But anyways, If you enter -1 in the field1 column you will get the error message generated by the cellvalidating event. If you correct the value to 1, the warning icon stays where it was as does the message and moreover you just can't use the close button anymore or change line in the grid , even though the data is now correct. You're stuck! The only way I found to close it was from the IDE stopping the app. I invite the gentlemen at Microsoft to take a look at this and come up with a solution ar at least an excuse ;-) Anyone with insight regarding this problem would be most appreciated, Bob Show quoteHide quote "Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message [attached file: Problem.zip]news:uO3bTyVFGHA.2444@TK2MSFTNGP11.phx.gbl... > Hi, > > "Bob" <bduf***@sgiims.com> wrote in message > news:%23zS3s1UFGHA.3856@TK2MSFTNGP12.phx.gbl... >> In a datagridview (vs2005, VB.net) I have two columns that are >> checkboxes. >> 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 wrote code in the cellvalidating event as follows. > > 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. > You can use the esc key to revert the value. But there is a problem in > your > code, you can't use "DataGridView[,].Value" for both CheckBox, only for > the > non-editing CheckBox, for the the editing CheckBox you need to use > e.FormattedValue. > > (Note, FormattedValue is either a Boolean (ThreeState=false) or a > CheckState > (ThreeState=true). > > Private Sub Datagrid1_CellValidating(ByVal sender As Object, ByVal e As > System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles > Datagrid1.CellValidating > > Me.Datagrid1.Rows(e.RowIndex).ErrorText = "" > Dim otherCheck As Boolean = False > > If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_1") Then > otherCheck = CBool(Datagrid1("Cell_2", e.RowIndex).Value) > End If > > If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_2") Then > otherCheck = CBool(Datagrid1("Cell_1", e.RowIndex).Value) > End If > > If ( otherCheck And CBool(e.FormattedValue) ) Then > Me.Datagrid1.Rows(e.RowIndex).ErrorText = "Can't have both values true." > e.Cancel = True > End If > > End Sub > > > HTH, > Greetings > > >> >> End If >> >> End Sub >> >> Say I checked just one checkbox Cell_1 to start, the code allows the >> change to be made. 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. 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.RowIndex).Value) it remains set to true. >> >> >> >> What am I doing wrong? I press the sacep key after the e,cancel and the >> message and I get the same problem. >> >> Any help appreciated, >> >> Bob >> >> >> >> >> >> >> >> > > Bart, I adapted your code to my datagridview, works like a charm. I'm going
to revisit the sample mdb that I sent to the newsgroup, I still wonder why that did not work. Oh by the way, I had to add an if condition to do the testing in the cellvalidating only when either of these two checkbox fields gets edited. otherwise the event does a validation on other types of fields and returns errors, but that was easy. I owe you one, Bob Show quoteHide quote "Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message news:uO3bTyVFGHA.2444@TK2MSFTNGP11.phx.gbl... > Hi, > > "Bob" <bduf***@sgiims.com> wrote in message > news:%23zS3s1UFGHA.3856@TK2MSFTNGP12.phx.gbl... >> In a datagridview (vs2005, VB.net) I have two columns that are >> checkboxes. 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 wrote code in the cellvalidating event as follows. > > 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. > You can use the esc key to revert the value. But there is a problem in > your code, you can't use "DataGridView[,].Value" for both CheckBox, only > for the non-editing CheckBox, for the the editing CheckBox you need to use > e.FormattedValue. > > (Note, FormattedValue is either a Boolean (ThreeState=false) or a > CheckState (ThreeState=true). > > Private Sub Datagrid1_CellValidating(ByVal sender As Object, ByVal e As > System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles > Datagrid1.CellValidating > > Me.Datagrid1.Rows(e.RowIndex).ErrorText = "" > Dim otherCheck As Boolean = False > > If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_1") Then > otherCheck = CBool(Datagrid1("Cell_2", e.RowIndex).Value) > End If > > If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_2") Then > otherCheck = CBool(Datagrid1("Cell_1", e.RowIndex).Value) > End If > > If ( otherCheck And CBool(e.FormattedValue) ) Then > Me.Datagrid1.Rows(e.RowIndex).ErrorText = "Can't have both values true." > e.Cancel = True > End If > > End Sub > > > HTH, > Greetings > > >> >> End If >> >> End Sub >> >> Say I checked just one checkbox Cell_1 to start, the code allows the >> change to be made. 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. 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.RowIndex).Value) it remains set to true. >> >> >> >> What am I doing wrong? I press the sacep key after the e,cancel and the >> message and I get the same problem. >> >> Any help appreciated, >> >> Bob >> >> >> >> >> >> >> >> > > Hi,
"Bob" <bduf***@sgiims.com> wrote in message Actually i thought about this and the reasoning was that if the validating news:OLH10aWFGHA.2012@TK2MSFTNGP14.phx.gbl... > Bart, I adapted your code to my datagridview, works like a charm. I'm > going to revisit the sample mdb that I sent to the newsgroup, I still > wonder why that did not work. > Oh by the way, I had to add an if condition to do the testing in the > cellvalidating only when either of these two checkbox fields gets edited. cell isn't one of the CheckBoxCell then 'otherCheck' couldn't be True so the following if statement would fail (because of the AND), but i forgot VB.NET doesn't use a short-circuiting AND operator by default and therefore CBool is used on other cells too. It should have been: .... If ( otherCheck AndAlso CBool(e.FormattedValue) ) Then .... Anyways, glad you got it working. Greetings Show quoteHide quote > otherwise the event does a validation on other types of fields and returns > errors, but that was easy. > I owe you one, > Bob > > "Bart Mermuys" <bmermuys.nospam@hotmail.com> wrote in message > news:uO3bTyVFGHA.2444@TK2MSFTNGP11.phx.gbl... >> Hi, >> >> "Bob" <bduf***@sgiims.com> wrote in message >> news:%23zS3s1UFGHA.3856@TK2MSFTNGP12.phx.gbl... >>> In a datagridview (vs2005, VB.net) I have two columns that are >>> checkboxes. 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 wrote code in the cellvalidating event as follows. >> >> 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. You can use the esc key to revert the value. But there is a problem >> in your code, you can't use "DataGridView[,].Value" for both CheckBox, >> only for the non-editing CheckBox, for the the editing CheckBox you need >> to use e.FormattedValue. >> >> (Note, FormattedValue is either a Boolean (ThreeState=false) or a >> CheckState (ThreeState=true). >> >> Private Sub Datagrid1_CellValidating(ByVal sender As Object, ByVal e As >> System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles >> Datagrid1.CellValidating >> >> Me.Datagrid1.Rows(e.RowIndex).ErrorText = "" >> Dim otherCheck As Boolean = False >> >> If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_1") Then >> otherCheck = CBool(Datagrid1("Cell_2", e.RowIndex).Value) >> End If >> >> If (Datagrid1.Columns(e.ColumnIndex).DataPropertyName = "Cell_2") Then >> otherCheck = CBool(Datagrid1("Cell_1", e.RowIndex).Value) >> End If >> >> If ( otherCheck And CBool(e.FormattedValue) ) Then >> Me.Datagrid1.Rows(e.RowIndex).ErrorText = "Can't have both values >> true." >> e.Cancel = True >> End If >> >> End Sub >> >> >> HTH, >> Greetings >> >> >>> >>> End If >>> >>> End Sub >>> >>> Say I checked just one checkbox Cell_1 to start, the code allows the >>> change to be made. 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. 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.RowIndex).Value) it remains set to true. >>> >>> >>> >>> What am I doing wrong? I press the sacep key after the e,cancel and the >>> message and I get the same problem. >>> >>> Any help appreciated, >>> >>> Bob >>> >>> >>> >>> >>> >>> >>> >>> >> >> > > 
Other interesting topics
Reading Binary File in VS2005
Bug or By Design... What version of SQL Server can I install in my Windows XP PC and.. LRC Calculation algorithm How to change a VB solution/project name? Migration of MSFLEXGRID to DATAGRID in vb.net... Bind dinamicly dlls without createobject Releasing a loaded assembly in ASP.NET 2.0 end sub and breakpoints Insert Column in Excel in VB .NET |
|||||||||||||||||||||||
