Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Parv
340
Restore cell value on BeforeExitEditMode Event
posted

Hi,

I do the validation on BeforeExitEditMode and keep the focus in cell if it the condition is not true. I want to restore the value of the cell if valid criteria is not met. My code is below:-

 

Private Sub UltraGrid1_BeforeExitEditMode(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.BeforeExitEditModeEventArgs) Handles UltraGrid1.BeforeExitEditMode

Dim result As DialogResult

Dim aCell As UltraGridCell

If e.CancellingEditOperation Then Return

'check code column and check if there is some value in it

aCell = UltraGrid1.ActiveCell

If (aCell.Column.Key = "Code") And Not (DBNull.Value.Equals(aCell.Text)) Then

'do validation here

If aCell.Text = "9" Then

If e.ForceExit Then

' If the UltraGrid must exit the edit mode, then cancel the

' cell update so the original value gets restored in the cell.

Me.UltraGrid1.ActiveCell.CancelUpdate()

Return

End If

result = MessageBox.Show("Invalid Value", "Test", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly, False)

If result = Windows.Forms.DialogResult.Yes Then

Me.UltraGrid1.ActiveCell.CancelUpdate() 'here i try to cancel with cell.cancelupdate but it doesn't restore the value

aCell.SelectAll()

CodeIsInValid = True

e.Cancel = True

End If

End If

End If

End Sub

 

Is there any way to achieve this?

Thanks in advance,

Parv

  • 235
    posted

    Try this: to cancel the update.

    

    Private Sub yourUltraGrid_BeforeCellUpdate(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.BeforeCellUpdateEventArgs) Handles ultraGrid1.BeforeCellUpdate
    

      ' You may update the if statement to match your logic
        If GetType(e.NewValue) != GetType(int) Then
             e.Cancel = true;
             MsgBox("Only integers are allowed in this field.");
        End If
    End Sub

  • 53790
    posted

    Hello Parv,

     

    Maybe one possible approach to achieve desire behavior is to include the code below in your ultraGrid1_BeforeExitEditMode() event.

    

    Private Sub ultraGrid1_BeforeExitEditMode(sender As Object, e As Infragistics.Win.UltraWinGrid.BeforeExitEditModeEventArgs)
     If ultraGrid1.ActiveCell.Column.Key = "B" AndAlso ultraGrid1.ActiveCell.Text <> "999" Then
      e.Cancel = True
      ultraGrid1.ActiveCell.SelectAll()
      ultraGrid1.ActiveCell.SelText = ultraGrid1.ActiveCell.Value.ToString()
     End If
    End Sub

    Please let me know if you have any questions.

    Regards