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