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