Gary

Gary

  • NA
  • 18
  • 49k

Creating a Quiz

Jun 29 2011 8:18 AM
Hello,

I am having a problem but i'm unsure as to whether or not there is a solution to it. My intention is to create a quiz, using an Access database table to store both the questions and the answers, that is, 1 column will contain the questions, and another column will contain the answers.
I will have a C# form, which when loaded, will have a question that has been randomly chosen from the database displayed onto it.

At the moment, what I am trying to do is to get the label that I have on my form populated with the text of one of my questions in the database. Here is my code:

[Code]
private void WindowsAnalysisQuiz_Load(object sender, EventArgs e)
        {
            //declare connection string using windows security
            string cnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Hannah\\Desktop\\WindowsAnalysisQuiz.accdb";

            //declare Connection, command and other related objects
            OleDbConnection conGet = new OleDbConnection(cnString);
            OleDbCommand cmdGet = new OleDbCommand();

            try
            {
                //open connection
                conGet.Open();

                cmdGet.CommandType = CommandType.Text;
                cmdGet.Connection = conGet;
                cmdGet.CommandText = "SELECT Question FROM WindowsAnalysisQuiz ORDER BY rnd()";

                label1.Text = cmdGet.CommandText["Question"];

                conGet.Close();
[/Code]

The line in bold is the problem I am getting. Apparently I am using invalid arguments. I have not managed to see any examples of quizzes using Access databases as a repository. It would be nice to know if I am trying to achieve something that isn't really possible!

Answers (2)