?
Solved

Datagridview Data Change Event

Posted on 2011-03-10
3
Medium Priority
?
1,386 Views
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

0
Comment
Question by:bhlabelle
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
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!

0
 

Author Comment

by:bhlabelle
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.
0
 

Author Closing Comment

by:bhlabelle
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.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month14 days, 16 hours left to enroll

770 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