public void selectQuestionNo()
{
try
{
// step 1: Create a connection
var result = Path.GetFullPath("InformationDatabase.mdf");
string strConnection = "Data Source=.\\sqlexpress;AttachDbFilename=" + result + ";User Instance=true;Integrated Security=True;Pooling=False;MultipleActiveResultSets=true";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
// step 2: fire a command
string username = UserInformation.getUserName();
// string quizno = onlineQuizSerialNo;
AllorUnsolved = UserInformation.getAllorSolved();
string strCommand = "";
if (AllorUnsolved == "Unsolved")
{
Unsolved = true;
strCommand = "SELECT QSN FROM Question EXCEPT SELECT QSN FROM Solve WHERE userID=@UN";
}
else if (AllorUnsolved == "All")
{
All = true;
strCommand = "SELECT QSN FROM Question";
}
SqlCommand objCommand = new SqlCommand(strCommand, objConnection);
objCommand.Parameters.Add(new SqlParameter("@UN", username));
// step 3: bind the result data with user interface
SqlDataReader reader = objCommand.ExecuteReader();
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
unsolvedQuestion.Add(reader[i].ToString());
}
}
reader.Close();
objConnection.Close();
if (unsolvedQuestion.Count == 0 && Unsolved == true)
{
MessageBox.Show("You have no unsolved Questions!");
Unsolved = false;
Question q = new Question();
q.ShowDialog();
}
else if (unsolvedQuestion.Count == 0 && All == true)
{
MessageBox.Show("Please Update Questions!\nDatabase is empty.");
All = false;
Question q = new Question();
q.ShowDialog();
}
makeValue(unsolvedQuestion);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Question q = new Question();
q.ShowDialog();
//MessageBox.Show(ex.Message);
}
}
