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; } }