{Resolved} VB.NET 2005 - DataGridView - CellValidating

[dbelley_office]

Everytime I validate a cell in my datagridview, it enters in the event multi times. So If there is an error I see the messagebox many times and if the value is correct, it still makes the validation twice.

EDIT:
One thing I just noticed. If on a line a provoque an error, I get the error message twice. If I change line and provoque an error, I get the error message 3 times and it continues on an on 4-5-6-7-8 times ... so it always increases by one. Anyone can explain that ?

Here is my code:

    'This line is in the function where I fill the grid. 
    AddHandler grdInfo.CellValidating, AddressOf ValidateGridEntry 

    Private Sub ValidateGridEntry(ByVal sender As Object, ByVal e As Windows.Forms.DataGridViewCellValidatingEventArgs) 

        Dim lngRet As Long = 0 

        If e.RowIndex < 0 OrElse e.FormattedValue.ToString = String.Empty Then Exit Sub 

        If e.ColumnIndex = grdInfo.Columns("regCode").Index Then 

            lngRet = ValiderReglement(e.FormattedValue.ToString.Trim) 
            If lngRet = 0 Then 

                ShowMessage(My.Resources.MSG_WARNING_CODE_REGLEMENT_INEXISTANT, mERROR) 
                e.Cancel = True 

            Else 

                If grdInfo.CommitEdit(DataGridViewDataErrorContexts.Commit) = False Then 
                    ShowMessage(My.Resources.MSG_WARNING_PROBLEME_COMMIT_CELLULE, mERROR) 
                End If 

            End If 

        End If 

    End Sub

[dbelley_office]

I am just moving up my message.
I did not find a solution yet.

[nmadd]

Perhaps it has something to do with the Handler getting added multiple times mistakenly. I came upon something very similar when I was playing around with the DataGridView. Try removing any old handler before you add the new one.

'This line is in the function where I fill the grid. 
RemoveHandler grdInfo.CellValidating, AddressOf ValidateGridEntry
AddHandler grdInfo.CellValidating, AddressOf ValidateGridEntry

[dbelley_office]

n madd !!

You are my new hero !!

Indeed, I have to call the function FillGrid at different times.
I didn't know the "AddHandler" was adding everytimes.

It is a good practice to always put the "RemoveHandler" line.

Thank you big time !!

[nmadd]

Glad to help.

Good luck on your project.