14.1.txt

《Microsoft Visual C# .NET 2003开发技巧大全》源代码

Listing 14.1 Detecting DataSet Changes
private void dgProduct_CurrentCellChanged(object sender, System.EventArgs e)
{
if( productsDS1.HasChanges() )
{
statusBar1.Text = “Modified”;
}
}
private void Form1_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
if( productsDS1.HasChanges() )
{
DialogResult result;
result = MessageBox.Show( this, “Would you like to save your changes?”,
“Northwind Products”, MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Question );
if( result == DialogResult.Cancel )
{
e.Cancel = true;
return;
}
else if( result == DialogResult.No )
{
return;
}
else
{
sqlDataAdapter1.Update( productsDS1 );
}
}
}