How to retrieve question from database one by one

Question

1.00/5 (1 vote)

See more:

I am Developing a on-line test application.
my requirements are-

1. Questions will be retrieved from database randomly.
2. Options are also shuffled if i start the test again.
3. One question at a time is displayed on the page and on next button click next question is displayed.

can any one give me the solution for that-
1. how to display one question at a time on the page
2. how to shuffle options.

thanks in advance

Posted 3-Oct-14 0:15am

Kriti Sharma 10400841

Add a Solution

Comments

George Jonsson 3-Oct-14 6:26am

If you have an integer ID for your question, you can use the Random class to get a number between you min and max IDs in your database table.
For how to display the question, there are tons of samples. Just search with your favorite engine.

Sinisa Hajnal 3-Oct-14 6:32am

Get whole test at once, that way you avoid having to watch for duplicates. You can store it in cache/cookie/session/however you see fit.

Option - retrieve them already shuffled. Good option for SQL Server is ORDER BY NEWID() which will sort the options by random generated GUIDs

3 solutions

Solution 1

In order to extract randomly your questions you have to provide an ordering criterion to your table of questions, a auto-increment field (say id) would fit very well.
Then you could use the random number generator (Random class) for extracting a random number and use it in your query:

SQL

select question from question_table where id=@random_number

If you don't want question repetitions (that is selecting two or more times the same question in the same test) then have a look at the algorithm shown in my tip: "Random extraction of 5 cards from a deck"[^].

Posted 3-Oct-14 0:26am

CPallini

Solution 3

How to shuffle options on each get

SQL

SELECT * FROM OPTIONS 
WHERE question = @your_question
ORDER BY NEWID()

Posted 3-Oct-14 0:34am

Sinisa Hajnal

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)

Snesh Prajapati · Accepted Answer · 2014-10-03T00:30:00

You get minimun and maximum value of question Id (minQId and maxQId) from database and choose a random ID as:

C#

Random rnd = new Random();
int questionIdToFetch = rnd.Next(minQId, maxQId);

Then get that complete question and display.

To suffle asnwers below link would be useful:
http://stackoverflow.com/questions/273313/randomize-a-listt-in-c-sharp[^]

Let me know if there is any further question.