We help IT Professionals succeed at work.

How do you handle data validation (OnRowValidating) in a DataGridView

FatalErr
FatalErr asked
on
Medium Priority
689 Views
Last Modified: 2012-05-07
If a user leaves a record in a DataGridView and they haven't entered a required field I keep getting system.Data.NoNullAllowedException. ..
I'm trying to catch it with the code below but it doesn't work.  Is there an easy way to do this?

Thanks,
Private Sub myDataGridView_RowValidating(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellCancelEventArgs) Handles myDataGridView.RowValidating
        Try
        Catch ex As NoNullAllowedException
            MessageBox.Show("You left a record without filling in all of the required fields " & ex.Message)
        End Try
    End Sub

Open in new window

Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I ended up using the DataError event which seems to be designed for what I needed.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.