Developing Online Quize Bank in ASP.net and C#

Question

0.00/5 (No votes)

See more:

Hello
I have started one as Asynchronous Learning system
in which Questions will be uploaded to a question bank (Database.)

and the upon request Random questions will be selected and displayed to the user
with question and Radio buttons for choices, then a feedback will be displayed when the form is submitted.

What kind of piece of code can be used to select questions from database randomly,
and display them in a well formed way???

Posted 23-Mar-12 6:01am

basitex

Add a Solution

Comments

Steve Maier 23-Mar-12 12:11pm

What version of C# / ASP.NET are you using?

basitex 24-Mar-12 16:35pm

ASP.NET 2010, with Ajax,

1 solution

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)

**R. Giskard Reventlov** · Answer 1 · 2012-03-23T06:27:00

Solution 1

You could use something like the following:

SQL

select top 1
    Column1,
    Column2,
    ...
from
    Table_Name
tablesample (n percent)

where n is any integer between 1 and 100.

Here is an article with more detail: Limiting Result Sets by Using TABLESAMPLE[^]

Posted 23-Mar-12 6:27am

R. Giskard Reventlov

Comments

Nelek 23-Mar-12 20:53pm

Hi Mark, I don't know if you already saw it but I have noticed that many QA where you have contributed are not getting your name by the "updated X hours ago".

R. Giskard Reventlov 24-Mar-12 9:58am

Thanks: hadn't noticed. Is it important? I really have no idea.

Nelek 25-Mar-12 7:15am

AFAIK, all QA work good, just your name missing in info. I don't know if it is important or not, just pointed it out.

basitex 24-Mar-12 16:33pm

thanks!