Generating 5 unique random records from a database....

--------------------------------------------------------------------------------

im using ASP.NET/VB.NET. i have a MS Access database of questions and 4 multiple choice answers for each question. i would like to know if it is possible to randomly generate 5 different questions on a page with its multiple choice answers from the database at the same time but making sure that each question displayed is not displayed again in one instance.

there are various examples on the net but have'nt found any that can help me solve this. im really stuck now....can anyone please help me out??????

Thanks........

Either store the questions in the DB per user, or maybe storing a custom DataTable object holding the question ID's in it, then put the data table in the Session or Cache objects. If you are using the Cache object, make sure that in the global.asax.vb file, you specify "Cache.Remove" in the Session_End method. That way, when the session ends, they can start over. Or you can use the Cache and specify an expiration period too, and do it that way. If you want a predefined expiration period, you can't use the Session object.

What level of retention do you want? User sessions time, 20 minutes, 1 day, 2 days, a month?

Brian Mains

hi brian,
thanks mate. yea ok will do. im designing this for a quiz system where users will be given multiple choice quizzes when they log into the site. im using sessions but i need to have a database with a standard set of questions that applies when the choose the option to take the quiz so i cannot have a sert of questions for each user. im fairly new to htis so have u come across any examples of this on the net? if so then the help is much appreciated and thanks for the help mate!!!