private void btnOK_Click(object sender, EventArgs e) { try { db.SubmitChanges(); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { if (dgvStudents.SelectedRows.Count == 0) { return; } using (var db = new StudentDBDataContext()) { foreach (DataGridViewRow row in dgvStudents.SelectedRows) { int id = int.Parse(row.Cells["Id"].Value.ToString()); var s = db.Students.Where(x => x.Id == id).SingleOrDefault(); try { db.Students.DeleteOnSubmit(s); } catch { } } db.SubmitChanges(); } LoadStudents(); }