public static DataSet getInfoProjectName(string IDStudent) { string[] para = new string[1] { "@ID" }; object[] value = new object[1] { IDStudent }; return(MyDB.FillDataSet("procedureProjectsForCombobox", CommandType.StoredProcedure, para, value)); }
public static DataSet getStudentScore(string PID) { string[] para = new string[1] { "@PID" }; object[] value = new object[1] { PID }; return(MyDB.FillDataSet("procedureGetAllScoreByProject", CommandType.StoredProcedure, para, value)); }
public DataSet CheckDangNhap() { string[] paras = new string[2] { "@Username", "@Password" }; object[] values = new object[2] { Username, Password }; return(MyDB.FillDataSet("procedureCheckDangNhap", CommandType.StoredProcedure, paras, values)); }
//public int getproject(string IDStudent) //{ // //DataTable check = data.readdata("select * from Project WHERE PID in ( SELECT Project_PID FROM StudentProjects WHERE Student_ID='" + IDStudent + "');"); // DataSet check = MyDB.Execute_Sql("Select distinct(Project.PID), Project.PName, Project.PContent, Project.PType, Project.PBegin, Project.PEnd, Score.score, Score.comment " + // "from Project Left Join Score ON(Project.PID = Score.PID)"+ // "Where Project.PID in (SELECT Project_PID FROM StudentProjects WHERE Student_ID = '" + IDStudent + "');"); // return check; //} public static DataSet FillDataSetProject(string IDStudent) { //DataSet check = MyDB.FillDataSet("Select distinct(Project.PID), Project.PName, Project.PContent, Project.PType, Project.PBegin, Project.PEnd, Score.score, Score.comment " + // "from Project Left Join Score ON(Project.PID = Score.PID)" + // "Where Project.PID in (SELECT Project_PID FROM StudentProjects WHERE Student_ID = '" + IDStudent + "');", CommandType.Text); string[] para = new string[1] { "@ID" }; object[] value = new object[1] { IDStudent }; return(MyDB.FillDataSet("procedureGetProjectsByStudent", CommandType.StoredProcedure, para, value)); }
internal DataSet FillDataSet_getProjectById() { DataSet ds = new DataSet(); string[] paras = new string[1] { "@PID" }; object[] values = new object[1] { PID }; ds = MyDB.FillDataSet("procedureGetBanByID", CommandType.StoredProcedure, paras, values); return(ds); }
public DataSet obtainInformationStudentByName() { DataSet ds = new DataSet(); string[] paras = new string[1] { "@Fullname" }; object[] values = new object[1] { ID }; ds = MyDB.FillDataSet("procedureObtainStudentByName", CommandType.StoredProcedure, paras, values); return(ds); }
public DataSet FillDataSet_getTaiKhoanByID() { DataSet ds = new DataSet(); string[] paras = new string[1] { "@ID" }; object[] values = new object[1] { ID }; ds = MyDB.FillDataSet("procedureGetTaiKhoanByID", CommandType.StoredProcedure, paras, values); return(ds); }
public static DataSet getStudentScore() { return(MyDB.FillDataSet("SELECT * FROM dbo.viewScore", CommandType.Text)); }
public static DataSet getProjectName() { return(MyDB.FillDataSet("SELECT * FROM dbo.viewProject", CommandType.Text)); }
public static DataSet StudentFeedback(string IDProject) { return(MyDB.FillDataSet("select * from Student WHERE ID in ( SELECT Student_ID FROM StudentProjects WHERE Project_PID='" + IDProject + "');", CommandType.Text)); }
public static DataSet FillDataSetTaiKhoan() { return(MyDB.FillDataSet("SELECT * FROM viewGetTaiKhoan", CommandType.Text)); }