Random question and answers from database to label.text and radiobutton.text

Question

0.00/5 (No votes)

See more:

C#

Hello, I have a task to make a quiz in C# WPF using the SQLite database.

I made a connection with the database Quiz with 7 Columns:

0. ID
1. Question
2. AnswerA
3. AnswerB
4. AnswerC
5. AnswerD
6. CorrectAnswer

Also, I have form from where I can add or delete questions and answers.

Now, the problem is:

When I click Start Quiz it's should open a new form that has a label with a random question from the database and 4 RadioButton with text from columns AnswerA, b, c, and D.

Any idea how could I make this?

Thank You.

What I have tried:

C#

I tried to Google solution but I didn't even find how to store info form database to radiobutton.text

Posted 3-Jun-20 1:56am

Member 14852089

Updated 3-Jun-20 2:02am

Add a Solution

Comments

ZurdoDev 3-Jun-20 7:57am

"click Start Quiz it's should open a new form that has a label with a random question from the database and 4 RadioButton with text from columns AnswerA, b, c, and D."

There are a lot of tasks in that request. So, where are you stuck?

1. You need a new form with a label on it and some radiobuttons.
2. You need to know how to open the form.
3. You need to know how to generate a random number between 1 and the number of questions you have.
4. You need to know how to retrieve a record from the database and populate the values in a control.
5. etc, etc. etc.

Break it down into the parts and then ask something specific.

F-ES Sitecore 3-Jun-20 7:58am

Your question is basically "how do I write this program". We don't mind giving specific answers to specific questions but this is too broad and vague. Break the problem into smaller problems and solve each one in turn. So find out how to select a random item from a SQLite database. Then find out how you use radio buttons, then find out how to store data in SQLite and so on.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Garth J Lancaster · Answer 1 · 2020-06-03T02:02:00

You need to learn how to break you problem into bite-size pieces

1) the first query you should do is a count of the number of rows (questions) in your table
2) you then generate a random number between 0 and # rows - 1
3) (this assumes the ID is sequential) from 2 you do a select where ID = the random number

....

I guess, since re-reading your question you say you can delete rows, you could replace 1,2 with
1) get a list of all valid ID's in the table
2) pick an ID randomly
3) get the matching row by ID

Once you get this far, you then have a row in your sql result that you can use to update the GUI

There are other ways of doing this of course

RickZeeland · Answer 2 · 2020-06-03T02:04:00

Solution 2

Take a look at: GitHub - Shashankocean/quizi: Desktop application quiz game like KBC ( WPF C#,Net , sqlite database )[^]

Posted 3-Jun-20 2:04am

RickZeeland