[RESOLVED] Cancel selection changed in datagridview

[PaulHarman]

Hi all,

Ive got a datagridview, which the user can put in to 'edit' mode by double clicking. If they then make changes but click to another row, I want to msg asking if they are sure they want to discard then changes. If they say No I want to stop the selection change from being made.

    Private Sub DataGridView1_SelectionChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataGridView1.SelectionChanged
        If edit = True Then
            Dim result As String = MsgBox("Are you sure you want to discard your changes?", MsgBoxStyle.YesNo)
            If result = vbYes Then
                clearedit()
            Else
                'Here is where I need to cancel the selection change
            End If
        Else
            clearedit()
        End If

[helderjsd]

I dont understand.

You wanna your datagridview pass to read only again??

[PaulHarman]

No, maybe I confused you by saying edit mode... ignore that!

How do I go back to the previous selected row on the selection changed event.

[PaulHarman]

Anyone?

[MarMan]

Store the row number then restore it:

grdComplete.Rows(intRow).Selected = True

grdComplete = DataGridView
intRow = index of the row that was being edited.

[PaulHarman]

Ahhh! thanks

[PaulHarman]

Cant give you rep again MarMan

[MarMan]

That's OK. The appreciation is appreciated.

[PaulHarman]

Just took a different way of thinking about it. Silly me! Thanks for the help