Fetch Random Question from SQL Database

Question

1.00/5 (2 votes)

See more:

Sir,

My database is like

--------------------------------
NO            int
Question      vachar(50)
op1           vachar(20)
op2           vachar(20)
op3           vachar(20)
op4           vachar(20)
Ans           vachar(20)
Subjectcode   varchar(20)
----------------------------------

Database has large number of questions of various SubjectCode.

I want to fetch some number of question from database based on subjectCode and from this numberof fetched question I want to display random question on to the web-page (one question per page)

So I hope you will help me...

Thanks a lot....

Posted 21-Sep-12 7:26am

Raiyani Bhavik k

Updated 21-Sep-12 7:35am

Nueman

v3

Add a Solution

Comments

Sandeep Mewara 21-Sep-12 13:30pm

And what is the issue? Did you try anything? Where are you stuck?

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)

Mehdi Gholam · Answer 1 · 2012-09-21T07:39:00

Solution 1

You can get the select count(*) from tablename of the row in the table, and use the .net Random class.

C#

Random r = new Random();
int i = r.Next(countFromTheTable)+1; // zero based add 1

Posted 21-Sep-12 7:39am

Mehdi Gholam

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2012-09-21T07:46:00

Solution 2

Please go through correct answer in Random Questions using DetailsView (Help)[^].

Best Codeproject Articles
1. Online Quiz[^]
2. How to make a random selection from an SQL table[^]

Posted 21-Sep-12 7:46am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 21-Sep-12 17:09pm

Please don't forget to mark this as accepted answer, if it has helped you in any way, so that it will be helpful for others to know the solution easily... You will also be awarded with points for accepting... :) :)

Thanks a lot...
Regards,
Tadit