private void btnSoft_Click(object sender, EventArgs e) { object r = cbbSoft.SelectedItem; if (r != null) { DemoQLSVEntities db = new DemoQLSVEntities(); if (cbbSoft.SelectedItem.ToString() == "MSSV") { var l = db.SinhVien.OrderBy(p => p.MSSV).Select(p => new { p.MSSV, p.NameSV, p.Age, p.LopSV.NameLop }); dataGridView1.DataSource = l.ToList(); } if (cbbSoft.SelectedItem.ToString() == "NameSV") { var l = db.SinhVien.OrderBy(p => p.NameSV).Select(p => new { p.MSSV, p.NameSV, p.Age, p.LopSV.NameLop }); dataGridView1.DataSource = l.ToList(); } if (cbbSoft.SelectedItem.ToString() == "Age") { var l = db.SinhVien.OrderBy(p => p.Age).Select(p => new { p.MSSV, p.NameSV, p.Age, p.LopSV.NameLop }); dataGridView1.DataSource = l.ToList(); } if (cbbSoft.SelectedItem.ToString() == "NameLop") { var l = db.SinhVien.OrderBy(p => p.LopSV.NameLop).Select(p => new { p.MSSV, p.NameSV, p.Age, p.LopSV.NameLop }); dataGridView1.DataSource = l.ToList(); } } else { return; } }
public void Show() { DemoQLSVEntities db = new DemoQLSVEntities(); var l = db.SinhVien.Select(p => new { p.MSSV, p.NameSV, p.Age, p.LopSV.NameLop }); dataGridView1.DataSource = l.ToList(); //string query = "select * from SinhVien"; //dataGridView1.DataSource = QLSV_DB.DataProvider.Instance.GetRecords(query); }
private void cbbLop_SelectedIndexChanged(object sender, EventArgs e) { string n = cbbLop.SelectedItem.ToString(); DemoQLSVEntities db = new DemoQLSVEntities(); if (n == "All") { Show(); } else { var l = db.SinhVien.Where(p => p.LopSV.NameLop == n.ToString()).Select(p => new { p.MSSV, p.NameSV, p.Age, p.LopSV.NameLop }); dataGridView1.DataSource = l.ToList(); } }
private void btSearch_Click(object sender, EventArgs e) { var db = new DemoQLSVEntities(); List <SinhVien> t = new List <SinhVien>(); foreach (SinhVien i in db.SinhVien) { if (i.NameSV.ToString().Contains(txtSearch.Text)) { t.Add(i); } } dataGridView1.DataSource = t; }
private void btnDel_Click(object sender, EventArgs e) { DataGridViewSelectedRowCollection r = dataGridView1.SelectedRows; DemoQLSVEntities db = new DemoQLSVEntities(); foreach (SinhVien i in db.SinhVien) { foreach (DataGridViewRow j in r) { if (i.MSSV == j.Cells["MSSV"].Value.ToString()) { db.SinhVien.Remove(i); } } } db.SaveChanges(); Show(); }
public void SetCBBLop() { DataTable dt = new DataTable(); var db = new DemoQLSVEntities(); if (cbbLop.Items != null) { cbbLop.Items.Clear(); } cbbLop.Items.Add(new CBBItems { Values = 0, Text = "All" }); foreach (SinhVien i in db.SinhVien) { cbbLop.Items.Add(new CBBItems { Values = Convert.ToInt32(i.ID_Lop.Value.ToString()), Text = i.LopSV.NameLop.ToString() }); } }