asked on

Datagridview Data Change Event

I have a datagridview linked to an Access database, and I want to prompt the user if they want to save the changes they make when they leave a row. I have it working fine, only I wish to prompt them only if there is a change to the data in the row they leave. Right now if the user is clicking the down arrow through the rows they are prompted each time they leave the row...not very good programming indeed!

Any help would be much appreciated.

Private Sub DataGridView1_RowLeave(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.RowLeave
Dim Response
Response = MsgBox("Do you want to save changes?", MsgBoxStyle.YesNo, "Warning!")
If Response = vbYes Then
  Call SaveData()
End If
End Sub

Open in new window

ASKER CERTIFIED SOLUTION

nepaluz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bhlabelle

ASKER

I like the idea. I'll probably work on it later today and respond accordingly.

And the data is not saved automatically, at least how I have it set up. I had to write an update command in the datasourceeditor.

bhlabelle

ASKER

Thank, very easy to impliment. I just added a string to set the value of the cell before the edit, added another string to set the value of the cell after the edit, if they are not the same then I prompt if the user wants to save the changes.