private void gridClasses_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { // Underlying row must have been edited TrophyDataSet.tblClassesRow r = ((e.Row.DataBoundItem as DataRowView).Row as TrophyDataSet.tblClassesRow); long count; using (TrophyDataSetTableAdapters.tblTrophiesTableAdapter adapter = new LDYC_Trophies.TrophyDataSetTableAdapters.tblTrophiesTableAdapter()) { count = (long)adapter.GetTrophyCountByClass(r.fldClassID); if (count > 0) { MessageBox.Show(this, string.Format("'{0}' cannot be deleted as it's being used by {1} trophies.", r.fldName, count), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; return; } } using (TrophyDataSetTableAdapters.tblWinnersTableAdapter adapter = new LDYC_Trophies.TrophyDataSetTableAdapters.tblWinnersTableAdapter()) { count = (long)adapter.GetWinnerCountByClass(r.fldClassID); if (count > 0) { MessageBox.Show(this, string.Format("'{0}' cannot be deleted as it's being used by {1} winners.", r.fldName, count), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; return; } } }
private void gridClasses_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { // Underlying row must have been edited TrophyDataSet.tblClassesRow r = ((e.Row.DataBoundItem as DataRowView).Row as TrophyDataSet.tblClassesRow); long count; using (TrophyDataSetTableAdapters.tblTrophiesTableAdapter adapter = new LDYC_Trophies.TrophyDataSetTableAdapters.tblTrophiesTableAdapter()) { count = (long)adapter.GetTrophyCountByClass(r.fldClassID); if (count > 0) { MessageBox.Show(this, string.Format("'{0}' cannot be deleted as it's being used by {1} trophies.", r.fldName, count), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; return; } } using (TrophyDataSetTableAdapters.tblWinnersTableAdapter adapter = new LDYC_Trophies.TrophyDataSetTableAdapters.tblWinnersTableAdapter()) { count = (long)adapter.GetWinnerCountByClass(r.fldClassID); if (count > 0) { MessageBox.Show(this, string.Format("'{0}' cannot be deleted as it's being used by {1} winners.", r.fldName, count), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; return; } } }