public DataSet LayDiemSinhVien()
{
string[] paramenters = { };
string[] values = { };
string sqlstring = "select * from dsDiemSV_View";
return(db.ExcuteQueryDataSet(sqlstring, System.Data.CommandType.Text, paramenters, values));
}
public DataSet LaySLSVTK()
{
string sqlString = "sp_SV_theo_Khoa";
string[] paramenters = { };
string[] values = { };
return(db.ExcuteQueryDataSet(sqlString, CommandType.StoredProcedure, paramenters, values));
}
//Chưa làm
public DataSet LayDiemTrungBinhTrongKhoaNamHoc(string Khoa, string NamHoc)
{
String sqlstring = "sp_LayDiemTrungBinhTrongKhoaNamHoc";
string[] paramenters = { "@MaKhoa", "@NamHoc" };
string[] values = { Khoa, NamHoc };
return(db.ExcuteQueryDataSet(sqlstring, CommandType.StoredProcedure, paramenters, values));
}
public DataSet LayLogin()
{
string sqlstring = "select * from dsLogin_View";
string[] paramenters = { };
string[] values = { };
return(db.ExcuteQueryDataSet(sqlstring, CommandType.Text, paramenters, values));
}
public DataSet LayThongTinTaiKhoan(string TenDN)
{
string sqlString = "sp_LayThongTinTaiKhoan";
string[] paramenters = { "@TenDangNhap" };
string[] values = { TenDN };
return(dbThongTinTaiKhoan.ExcuteQueryDataSet(sqlString, CommandType.StoredProcedure, paramenters, values));
}
