public static QuizInfo GetInformation() { OleDbCommand cmd; OleDbDataReader reader; QuizInfo quizInfo = new QuizInfo(); cmd = new OleDbCommand("SELECT * FROM QGEN_DATA;", conn); reader = cmd.ExecuteReader(); while(reader.Read()) { quizInfo.Name = reader.GetString(0); quizInfo.Date = reader.GetDateTime(1); quizInfo.Number = int.Parse(reader.GetValue(2).ToString()); string strQuizTime = reader.GetValue(3).ToString(); string[] quizTime = strQuizTime.Substring(strQuizTime.IndexOf(' ') + 1).Split(':'); quizInfo.Time = new TimeSpan(int.Parse(quizTime[0]), int.Parse(quizTime[1]), 0); quizInfo.PassingGrade = float.Parse(reader.GetValue(4).ToString()); quizInfo.Subject = reader.GetString(5); quizInfo.Instructor = reader.GetString(6); quizInfo.Class = reader.GetString(7); quizInfo.School = reader.GetString(8); } return quizInfo; }
public static QuizInfo GetInformation() { OleDbCommand cmd; OleDbDataReader reader; QuizInfo quizInfo = new QuizInfo(); cmd = new OleDbCommand("SELECT * FROM QGEN_DATA;", conn); reader = cmd.ExecuteReader(); while (reader.Read()) { quizInfo.Name = reader.GetString(0); quizInfo.Date = reader.GetDateTime(1); quizInfo.Number = int.Parse(reader.GetValue(2).ToString()); string strQuizTime = reader.GetValue(3).ToString(); string[] quizTime = strQuizTime.Substring(strQuizTime.IndexOf(' ') + 1).Split(':'); quizInfo.Time = new TimeSpan(int.Parse(quizTime[0]), int.Parse(quizTime[1]), 0); quizInfo.PassingGrade = float.Parse(reader.GetValue(4).ToString()); quizInfo.Subject = reader.GetString(5); quizInfo.Instructor = reader.GetString(6); quizInfo.Class = reader.GetString(7); quizInfo.School = reader.GetString(8); } return(quizInfo); }
public static void SetInformation(QuizInfo info) { OleDbCommand cmd; cmd = new OleDbCommand("DELETE * FROM QGEN_DATA;", conn); cmd.ExecuteNonQuery(); cmd = new OleDbCommand( String.Format("INSERT INTO QGEN_DATA VALUES('{0}', '{1}', {2}, '{3}', '{4}', '{5}', '{6}', '{7}', '{8}');", info.Name.Replace("'", "''"), info.Date, info.Number, info.Time.ToString(), info.PassingGrade, info.Subject.Replace("'", "''"), info.Instructor.Replace("'", "''"), info.Class.Replace("'", "''"), info.School.Replace("'", "''") ), conn); cmd.ExecuteNonQuery(); }
public static void SetInformation(QuizInfo info) { OleDbCommand cmd; cmd = new OleDbCommand("DELETE * FROM QGEN_DATA;", conn); cmd.ExecuteNonQuery(); cmd = new OleDbCommand( String.Format("INSERT INTO QGEN_DATA VALUES('{0}', '{1}', {2}, '{3}', '{4}', '{5}', '{6}', '{7}', '{8}');", info.Name.Replace("'", "''"), info.Date, info.Number, info.Time.ToString(), info.PassingGrade, info.Subject.Replace("'", "''"), info.Instructor.Replace("'", "''"), info.Class.Replace("'", "''"), info.School.Replace("'", "''") ), conn); cmd.ExecuteNonQuery(); }
/// <summary> /// Opens a quiz file. /// </summary> private void OpenQuiz() { QGenDB.Connect(this.filename); object[] row; ClearAllLists(); for(int i = 0; i < QGenDB.GetNumberOfRows("MC"); i++) { row = QGenDB.RetrieveQuestion(i)["MC"]; AddToList( i, row[0].ToString(), row[1].ToString(), row[2].ToString(), row[3].ToString(), row[4].ToString(), row[5].ToString() ); } for(int i = 0; i < QGenDB.GetNumberOfRows("TF"); i++) { row = QGenDB.RetrieveQuestion(i)["TF"]; AddToList( i, row[0].ToString(), bool.Parse(row[1].ToString()) ); } quizInfo = QGenDB.GetInformation(); UpdateQuizInformation(); this.tabTest.SelectedIndex = 0; UpdateLength(); UpdateEditPanel(); ShowLastQuestion(); QGenDB.Disconnect(); }