private void ViewAllExpenditure() { var db = new OOPCSEntities(); var expenditures = db.Expenditures.ToArray(); var expenditureViews = new ExpenditureView[expenditures.Length]; for (int i = 0; i < expenditureViews.Length; i++) { expenditureViews[i] = new ExpenditureView(expenditures[i]); } this.grdExpenditures.DataSource = expenditureViews; }
void grdExpenditures_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 46) { if (this.grdExpenditures.SelectedRows.Count == 1) { if (MessageBox.Show("do you want to delete this?") == System.Windows.Forms.DialogResult.OK) { ExpenditureView selected = (ExpenditureView) this.grdExpenditures.SelectedRows[0].DataBoundItem; var db = new OOPCSEntities(); Expenditure deleted = db.Expenditures.Find(selected.id); db.Expenditures.Remove(deleted); db.SaveChanges(); this.ViewAllExpenditure(); } } } }