DataGridView RowValidating e.Cancel locks user input.

Sign in to answer this question.

• GD

  Grunting Dwarf3y agoPosted Jul 21, 2023, 11:34 PM

  Hi James,

  You suggested to comment out the ElseIf branch, saying it was unnecessary.

  However what the ElseIf condition was doing is preventing that both, % and Price, be not zero at the same time.

  The rule is that at least one, and only one, of both (either % or Price) can/must be not zero.
• 

  James Axsom8y agoPosted Jul 2, 2018, 11:17 PM

  Hi, Asfand.  I fixed your issue.

  Here you go!

   

  1. Private Sub dgvMain_RowValidating(sender As Object, e As DataGridViewCellCancelEventArgs) Handles dgvMain.RowValidating  
  2.   
  3.     Dim bolCancelEvent As Boolean = False  
  4.   
  5.     Try  
  6.   
  7.         If e.RowIndex < 0 OrElse e.ColumnIndex < 0 Then Exit Try  
  8.   
  9.         dgvMain.EndEdit()  
  10.   
  11.         Dim objSourceDataViewRow As DataGridViewRow = dgvMain.Rows(e.RowIndex)  
  12.   
  13.         UtilityHelper.ClearDataGridViewRowErrors(objSourceDataViewRow)  
  14.   
  15.         If UtilityHelper.CellHasValidValue(objSourceDataViewRow, colProductName.Index) OrElse  
  16.                 UtilityHelper.CellHasValidValue(objSourceDataViewRow, colOrderPercentage.Index) OrElse  
  17.                 UtilityHelper.CellHasValidValue(objSourceDataViewRow, colOrderPrice.Index) Then  
  18.   
  19.             Dim strProductName As String = UtilityHelper.GetCellValue(objSourceDataViewRow, colProductName.Index)  
  20.   
  21.             If String.IsNullOrEmpty(strProductName) Then  
  22.                 bolCancelEvent = True  
  23.                 UtilityHelper.SetDataGridViewRowErrors(objSourceDataViewRow, "Product name is required.")  
  24.             End If  
  25.   
  26.             Dim decOrdererPercentage As Decimal = UtilityHelper.GetCellNumericValue(objSourceDataViewRow, colOrderPercentage.Index)  
  27.             Dim decOrdererPrice As Decimal = UtilityHelper.GetCellNumericValue(objSourceDataViewRow, colOrderPrice.Index)  
  28.   
  29.             If decOrdererPercentage = 0 AndAlso decOrdererPrice = 0 Then  
  30.                 bolCancelEvent = True  
  31.                 UtilityHelper.SetDataGridViewRowErrors(objSourceDataViewRow, "Order % or Order Price is required.")  
  32.   
  33.                 ' FIX IS RIGHT HERE - YOU DON'T THIS. DONT USE <> IN VB.NET  
  34.                 ' the If Statement above is sufficient and works.  
  35.   
  36.                 'ElseIf decOrdererPercentage <> 0 AndAlso decOrdererPrice <> 0 Then  
  37.                 '    bolCancelEvent = True  
  38.                 '    UtilityHelper.SetDataGridViewRowErrors(objSourceDataViewRow, "Order % or Order Price is required.")  
  39.   
  40.             End If  
  41.   
  42.         End If  
  43.   
  44.         e.Cancel = bolCancelEvent  
  45.   
  46.         If bolCancelEvent Then  
  47.             dgvMain.Focus()  
  48.         End If  
  49.   
  50.     Catch ex As Exception  
  51.         UtilityHelper.ProcessException(System.Reflection.MethodBase.GetCurrentMethod(), ex)  
  52.     End Try  
  53. End Sub