private void LoadStudents() { using (var db = new StudentDBDataContext()) { var students = from s in db.Students select new { s.Id, s.StudentName, s.Batch.BatchName, s.Birthday, s.Phone, s.Address }; dgvStudents.DataSource = students; dgvStudents.Columns["Id"].HeaderText = "Mã sinh viên"; dgvStudents.Columns["StudentName"].HeaderText = "Tên sinh viên"; dgvStudents.Columns["BatchName"].HeaderText = "Lớp"; dgvStudents.Columns["Birthday"].HeaderText = "Ngày sinh"; dgvStudents.Columns["Birthday"].DefaultCellStyle.Format = "dd/MM/yyyy"; dgvStudents.Columns["Id"].DefaultCellStyle.Format = "D5"; dgvStudents.Columns["Id"].Width = 90; dgvStudents.Columns["Id"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvStudents.Columns["Id"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; } }
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(); }