public DataSet getAllCourses(Course_tblDTO course_tbldto) { string query = "SELECT * FROM teacher_takes,course_tbl,teacher_tbl WHERE teacher_tbl.teacher_id=teacher_takes.teacher_id and teacher_takes.course_id=course_tbl.course_id and teacher_tbl.email='" + course_tbldto.EMAIL + "'"; if (dbconnect.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection); mysqlAdapter = new MySqlDataAdapter(cmd); dataSet = new DataSet(); mysqlAdapter.Fill(dataSet); dbconnect.CloseConnection(); return(dataSet); } else { return(dataSet); } }
public DataSet getStuId(Course_tblDTO course_tbldto) { string query = "SELECT * FROM student_takes WHERE year ='" + course_tbldto.YEAR + "' and semester ='" + course_tbldto.SEMESTER + "' and course_id ='" + course_tbldto.COURSE_ID + "'"; if (dbconnect.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection); mysqlAdapter = new MySqlDataAdapter(cmd); dataSet = new DataSet(); mysqlAdapter.Fill(dataSet); dbconnect.CloseConnection(); return(dataSet); } else { return(dataSet); } }
public DataSet getSem(Course_tblDTO course_tbldto) { //string query = "select distinct on year * from student_takes WHERE course_id ='" + course_tbldto.COURSE_ID + "'"; string query = "SELECT * from student_takes GROUP BY semester"; if (dbconnect.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection); mysqlAdapter = new MySqlDataAdapter(cmd); dataSet = new DataSet(); mysqlAdapter.Fill(dataSet); dbconnect.CloseConnection(); return(dataSet); } else { return(dataSet); } }