public static string GetEssayAnswer(int questionid) { MySqlConnection con = new MyConnection().getConnection(); con.Open(); string answer = ""; string query = "SELECT answers.Answer FROM answers WHERE answers.QuestionID=" + questionid + " "; MySqlDataAdapter da = new MySqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow dr in dt.Rows) { answer = dr[0].ToString(); } return(answer); }
public static void GetObjectives(int userId) { MySqlConnection con = new MyConnection().getConnection(); con.Open(); string query = "SELECT exam_answers.Answer FROM exam_answers WHERE exam_answers.UserID=" + userId + " "; MySqlDataAdapter da = new MySqlDataAdapter(query, con); DataTable dt = new DataTable(); da.Fill(dt); int x = 0; foreach (DataRow dr in dt.Rows) { x++; objectives[x] = dr[0].ToString(); } }
/// <summary> /// GET THE TOTAL NUMBER OF QUESTIONS THAT WAS LOADED /// </summary> /// <returns></returns> public static int getLast() { MySqlConnection con = new MyConnection().getConnection(); string TotalQuestion = "SELECT COUNT(QuestionID) FROM questions"; con.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(TotalQuestion, con); DataTable dt = new DataTable(); adapter.Fill(dt); var last = 0; int x = dt.Rows.Count; if (x > 0) { foreach (DataRow dr in dt.Rows) { last = Int32.Parse(dr[0].ToString()); } } return(lastQuestion = last); }
public static int NumberOfQuestion() { MySqlConnection con = new MyConnection().getConnection(); string TotalQuestionNo = "SELECT No_of_questions FROM set_exam"; con.Open(); MySqlDataAdapter adapter = new MySqlDataAdapter(TotalQuestionNo, con); DataTable dt = new DataTable(); adapter.Fill(dt); var Number = 0; int x = dt.Rows.Count; if (x > 0) { foreach (DataRow dr in dt.Rows) { Number = Int32.Parse(dr[0].ToString()); } } return(Number); }