Prompt While Leaving a Row in Datagridview?

Question

5.00/5 (1 vote)

See more:

Hi All,

I have a Datagridview in Form1,and I am using Datatable as DataSource to Datagridview.

When User Edits Any Cell Value in particular Row, and Leaves that Row without Save Or Update, it should prompt a message saying that "You Want To Save Changes Or Not"

Any Idea or Suggestion would be appreciated.

Regards,
Pawan.

Posted 14-Oct-10 18:58pm

Pawan Kiran

Updated 14-Oct-10 21:31pm

Dalek Dave

v3

Add a Solution

Comments

Dalek Dave 15-Oct-10 3:32am

Edited for Readability.

Henry Minute 15-Oct-10 8:54am

Well done for finding a solution. I have up voted your question for the effort.

Pawan Kiran 25-Oct-10 0:02am

I haven't Find the Solution Perfectly.
can some body help me on this please.

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)

Henry Minute · Answer 1 · 2010-10-14T21:09:00

Solution 1

You can use the DataGridView.OnSelectionChanged[^], DataGridView.OnRowEnter[^], DataGridView.OnRowLeave[^] events, to name but three of the many ways to do this.

Also think about the various Validating events.

Why not read the documentation to see if you can find better ways.

Posted 14-Oct-10 21:09pm

Henry Minute

Updated 14-Oct-10 21:14pm

v2

Comments

Pawan Kiran 15-Oct-10 8:50am

Hi Thanks to your post,

i considered CellLeaving also,
so I have used CellBeginEdit,CellEndEdit Events to solve my problem

But an Exception Prevents me to Solve my issue.

here is my code:

int originalvalue = 0;
private void dgridSLFElement_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
try
{
if (dgridSLFElement.Columns[dgridSLFElement.CurrentCell.ColumnIndex].Name.Equals("No of Clusters"))
{
originalvalue = string.IsNullOrEmpty(dgridSLFElement.CurrentCell.Value.ToString()) ? 0 : Convert.ToInt32(dgridSLFElement.CurrentCell.Value);
}
else
{
original_value = this.dgridSLFElement.CurrentCell.Value.ToString();
}
}
catch (Exception ex)
{
DataClass.LogError(ex);
}
}
private void dgridSLFElement_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgridSLFElement.Columns[dgridSLFElement.CurrentCell.ColumnIndex].Name.Equals("No of Clusters"))
{
if (this.dgridSLFElement.CurrentCell.Value.ToString() == originalvalue.ToString())
{
need_save = false;
}
else
{
need_save = true;
DialogResult dr = MessageBox.Show("Want To Update Changes Yes/No", "Alert", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
saveSLFElement(this.dgridSLFElement.CurrentCell.RowIndex);
}
else
{ dgridSLFElement[this.dgridSLFElement.CurrentCell.ColumnIndex, this.dgridSLFElement.CurrentCell.RowIndex].Value = originalvalue.ToString();
}
}
}
}
catch (Exception ex)
{
DataClass.LogError(ex);
}
}

While Executing Code At this point
saveSLFElement(this.dgridSLFElement.CurrentCell.RowIndex)
i am getting an exception, saying that

Operation is not valid because it results in a reentrant call to the SetCurrentCellAddressCore function.

Above Method Contains a PopupForm, GridViewBindMethod()..

Could you please Rectify my problem..

Thanks in advance.
Pawan.