Datagridview Data Change Event

Posted on 2011-03-10
Medium Priority
Last Modified: 2012-05-11
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

Question by:bhlabelle
  • 2
LVL 17

Accepted Solution

nepaluz earned 2000 total points
ID: 35094781
If the grid is bound to the datasource, I am not sure if the data is not aved automatically, however, you could create a global variable to hold the value of the cell being EDITED by handling the CellBeginEdit and comparing the value in CellEndEdit. If the values are different, then call your prompt else be quiet!


Author Comment

ID: 35094960
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.

Author Closing Comment

ID: 35097069
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.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question