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)); }