//load điểm theo mã học sinh
public DataSet timDiemTheoMaHS(int maHS)
{
SqlParameter MaHS = new SqlParameter("@maHS", maHS);
List <SqlParameter> HS = new List <SqlParameter>();
HS.Add(MaHS);
return(db.ExecuteQueryDataSet("timDiemTheoMaHS", CommandType.StoredProcedure, HS));
}
public DataSet loadAllClass()
{
return(db.ExecuteQueryDataSet("HienToanBoLop", CommandType.StoredProcedure));
}
public DataSet LayNguoiDung()
{
return(db.ExecuteQueryDataSet("select * from taikhoan", CommandType.Text));
}
public DataSet LaySach()
{
return(db.ExecuteQueryDataSet("select * from muonsach", CommandType.Text));
}
public DataSet LayNXB()
{
return(db.ExecuteQueryDataSet("select * from tacgia", CommandType.Text));
}
public DataSet LayDocGia()
{
return(db.ExecuteQueryDataSet("select * from docgia", CommandType.Text));
}
public DataSet Laytt()
{
return(db.ExecuteQueryDataSet("select * from thongbao", CommandType.Text));
}
public DataSet loadGV()
{
return(db.ExecuteQueryDataSet("select * from GiaoVien", CommandType.Text));
}
public DataSet LaySoBan()
{
return(db.ExecuteQueryDataSet("select count(*) from Ban", CommandType.Text));
}
public DataSet loadData()
{
return(db.ExecuteQueryDataSet("HienToanBoHocSinh", CommandType.StoredProcedure));
}
public DataSet loadMH()
{
return(db.ExecuteQueryDataSet("loadMH", CommandType.StoredProcedure));
}
