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 = ""; } }