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