public void LoadGridview()
{
SinhVienDAO sv = new SinhVienDAO();
drkhoa.DataSource = sv.Getdata("SELECT MaKhoa,TenKhoa FROM Khoa");
drkhoa.DataTextField = "TenKhoa";
drkhoa.DataValueField = "MaKhoa";
drkhoa.DataBind();
GridView1.DataSource = sv.Getdata("SELECT MaSV,HoTen,NgaySinh,GioiTinh,TenKhoa,Lop,TenChuTro,SDT,DiaChi,NgayDen,NgayDi,TenKhoa FROM SinhVien,Khoa");
GridView1.DataBind();
}
protected void find_Click(object sender, EventArgs e)
{
SinhVienDAO svdao = new SinhVienDAO();
if (!svdao.CheckUser(txttim.Text.Trim()))
{
lbthongbao.Text = "Không tìm thấy";
}
else
{
GridView1.DataSource = svdao.Getdata("SELECT MaSV,HoTen,NgaySinh,GioiTinh,TenKhoa,Lop,TenChuTro,SDT,DiaChi,NgayDen,NgayDi,TenKhoa FROM SinhVien,Khoa WHERE MaSV='" + txttim.Text + "' ");
GridView1.DataBind();
lbthongbao.Text = "";
}
}