Random Questions Generation from the database

Question

I have 100 questions in a Access database

If i need 50 question I should type in the text box and press the button.

When i press the button , it should randomly select 50 questions and display in gridview from the access database

How to do This in Windows form application c# using access database

Kunal Vaishya · Answer

You can also try this SELECT top 50 * FROM [Table1] ORDER BY NewId()

rashmi kc · Answer

SELECT top 50 * FROM [Table1] ORDER BY Rnd([serialnum]*now() I used this Query and It is working Now from each button on click its the different questions should randomly selected and it should display What is the code for this

rashmi kc · Answer

SELECT top 50 * FROM [Table1] ORDER BY Rnd([serialnum]*now() I used this Query and It is working Now from each button on click its the different questions should randomly selected and it should display What is the code for this

rashmi kc · Answer

SELECT top 50 * FROM [Table1] ORDER BY Rnd([serialnum]*now() I used this Query and It is working Now from each button on click its the different questions should randomly selected and it should display What is the code for this

Kunal Vaishya · Answer

you can create query like this in sql Select QuestionId QuestionText From QuestionTable Order By newid() try in Access may be it will help you