protected void seach_Click(object sender, EventArgs e) { Lop_Xl xl = new Lop_Xl(); DataClasses1DataContext db = new DataClasses1DataContext(); var loc = xl.timten(txttimsinhvien.Text); if (listloc.Text == "Tên") { dgvsearch.DataSource = from a in db.tlb_sinhviens where a.TenSV.Contains(txttimsinhvien.Text) select a; } else if (listloc.Text == "MSSV") { dgvsearch.DataSource = from a in db.tlb_sinhviens where a.MaSV.Contains(txttimsinhvien.Text) select a; } else if (listloc.Text == "Địa Chỉ") { dgvsearch.DataSource = from a in db.tlb_sinhviens where a.DiaChi.Contains(txttimsinhvien.Text) select a; } else if (listloc.Text == "Lớp") { dgvsearch.DataSource = from a in db.tlb_sinhviens where a.MaLop.Contains(txttimsinhvien.Text) select a; } else if (listloc.Text == "CVHT") { dgvsearch.DataSource = from a in db.tlb_sinhviens where a.TenCVHT.Contains(txttimsinhvien.Text) select a; } dgvsearch.DataBind(); }
protected void btxemdiem_Click(object sender, EventArgs e) { Lop_Xl xl = new Lop_Xl(); DataClasses1DataContext db = new DataClasses1DataContext(); dgvxemdiem.DataSource = from c in db.tlb_sinhviens join p in db.tlb_diemhks on c.MaSV equals p.MSSV where c.MaLop == DropDownlop.Text && p.HK == DropDownhk.Text && p.Namhoc == DropDownnamhoc.Text select new { MaSV = p.MSSV, c.TenSV, c.MaLop, p.HK, p.Namhoc, p.DiemTB, p.DiemRL, p.Xeploai }; dgvxemdiem.DataBind(); }