Help with mcq(muliple choose questions) form

[Seema_r101]

Hi
I have to do a webform. I have to enter 100 questions into database. have 4 possible answers (A, B, C, D). The questions has to be randomly choosen. Example of 20 questions. And if just say 5 people are answering this questions. They all must have different answers.
Just for an example,somthing like this

1)What color is the sky?
A. pink B. yellow C. orange D. blue

1)What color is the sky?
A. blue B. orange C. pink D. yellow

1)What color is the sky?
A. yellow B. pink C. blue D. orange

2) What color is grass?
A. yellow B. green C. blue D. orange

2) What color is grass?
A. green B. yellow C. blue D. orange
and so on.

The point of this is that there is no copying. Can someone help me with this please.


Im using sql server 2005 and vb.net

Tips and code will really be appreicated

Thanks for taking the time to read this

[mendhak]

Quite straightforward. Store the questions in a table. Store its corresponding possible answers in another table. When you present the questions, use RND to select random rows out of the corresponding answers. You cannot guarantee that users will always get different possible answers but you can greatly increase the probability.