How can i check if the user has changed the column value but forgot to hit Save button in a Datagridviewand display warning that Data not saved

Question

1.00/5 (1 vote)

See more:

Hi All,

I have a tab which has a Datagridview where user is allowed to edit a particular column and a button ' Save'which they shud hit inorder to Save. If the user edits the column and forgets to hit Save i need to display warning that the Data is not saved. How do i do this ?

I tried

Private Sub Gridview1_CurrentCellDirtyStateChanged(sender As Object, e As EventArgs) Handles Gridview1.CurrentCellDirtyStateChanged
       If Gridview1.IsCurrentCellDirty Then
           Gridview1.CommitEdit(DataGridViewDataErrorContexts.Commit)
       End If
   End Sub

   Private Sub GridView1_CellValueChanged(sender As Object, e As DataGridViewCellEventArgs) Handles Gridview1.CellValueChanged
       If (e.ColumnIndex = 3) Then
           If (btnAdd.Enabled = True And bBtnClicked = False) Then
               MsgBox("Data  not saved.")

           End If
       End If
   End Sub

This basically throws error on every cell change event. I don't want this. I want to display only when the user leaves the tab . Please help. Thanks.

Posted 23-Sep-13 4:46am

vidkaat

Updated 23-Sep-13 5:08am

Richard C Bishop

v5

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-09-23T05:16:00

Solution 1

Okay, so what's the problem? Don't show this message box. Instead, just have a Boolean flag modified and set it to true instead, silently. Later on, when the user changes the tab, check up this flag and process accordingly.

—SA

Posted 23-Sep-13 5:16am

Sergey Alexandrovich Kryukov

Comments

vidkaat 23-Sep-13 11:58am

I tried to do as wat you said. But I am also validating cell value using CellValidating event. If i use the above validation my cell validating does not seem to work .Help me with it.

My cellvalidating event has the validation to check if the value entered by the user is greater than the existing value. If not i popup a message. I need to validate this and also i need to check if the user has saved his changes.