Forcing Data to be written to DataSet

[Guest]

The issue: I have a grid which has a dataset as the datasource.

If a user enters data in a textbox on the grid and then clicks on the close
button of the form (the red X in the upper right corner), no events fire for
the grid or the control that the user was typing in.

The closing event of the form does fire, and I check there to see if any
changes need to be saved. If the user changes rows in the form, the typed
data is transmitted to the dataset. However, if the user goes directly for
the close button, the data is not transmitted to the dataset, and the dataset
does not know there are changes to be saved.

So the question is, how to force the events to fire? In another language,
we would use the SetFocus() method to set the focus to a control on the grid
which would fire the necessary events. But how do I do this in C#?

Greg

 

[Cor Ligthert]

Greg,

The problem is that you do not know if the user want to update or not.
However let assume that that is your approach that there will be an update.

Than you can use the closing event to catch that clicking the X.
(you need than the endcurrentedit to force a row change)

http://msdn.microsoft.com/library/d...mscurrencymanagerclassendcurrentedittopic.asp

I hope this helps,

Cor

 

[Dave]

I'd like to add to Cor's explaination:

The closing event is cancellable, so it may be more appropriate to prompt the user to save changes instead of assuming they want the
changes saved.

protected override void OnClosing(CancelEventArgs e)
{
// Implement a method to check if the form has changes, named "IsDirty"
if (IsDirty() &&
MessageBox.Show(this, "Save Changes",
"You have unsaved changes.\r\nAre you sure you want to close the application?", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning, MessageBoxDefaultButton.2) == DialogResult.No))
{
e.Cancel = true;
}

base.OnClosing(e);
}