protected void ddlMaSV_SelectedIndexChanged(object sender, EventArgs e)
{
myContext = new QuanLyHocDBDataContext(strCon);
var sMyQuery = from i in myContext.SinhViens
join j in myContext.KhoaDaoTaos
on i.MaKhoa equals j.MaKhoa
where i.MaSV == ddlMaSV.SelectedValue.ToString()
select new
{
i.MaSV,
i.HoTen,
j.TenKhoa
};
GrvData.DataSource = sMyQuery;
GrvData.DataBind();
}
protected void btnTim_Click(object sender, EventArgs e)
{
myContext = new QuanLyHocDBDataContext(strCon);
var myDataContext = from i in myContext.SinhViens
join j in myContext.KhoaDaoTaos
on i.MaKhoa equals j.MaKhoa
where i.HoTen.Contains(txtTen.Text)
select new
{
i.MaSV,
i.HoTen,
j.TenKhoa
};
GrvData.DataSource = myDataContext;
GrvData.DataBind();
}
