private void sqlDataAdapter1_RowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)
{
NortwindDataSet.CustomersRow CustRow = (NortwindDataSet.CustomersRow)e.Row; //h
MessageBox.Show(CustRow.CustomerID.ToString() + " has been updated");
northwindDataSet1.Customers.Clear();
sqlDataAdapter1.Fill(northwindDataSet1.Customers);
}
private void sqlDataAdapter1_RowUpdating(object sender, System.Data.SqlClient.SqlRowUpdatingEventArgs e)
{
NortwindDataSet.CustomersRow CustRow = (NortwindDataSet.CustomersRow)e.Row; //h
DialogResult response = MessageBox.Show("Continue updating " +
CustRow.CustomerID.ToString() + "?", "Continue Update?",
MessageBoxButtons.YesNo);
if (response == DialogResult.No)
{
e.Status = UpdateStatus.SkipCurrentRow;
}
}
