to select random questions from database

Question

hi i have 500 questions in my database and i want 50 questions randomly selected from it help me out regards rajnikar ballari

Suthish Nair · Answer

http://msdn.microsoft.com/en-us/library/cc441928.aspx http://stackoverflow.com/questions/19412/how-to-request-a-random-row-in-sql

arjunan Selvam · Answer

Hi I hope you are picking questions from the database as follows Select Question from Quiz where QuestionId=@ID You can use random class to generate random numbers.you can even mention minimum and maximum value in the random number generation as follows . //Sample Code Snippet Random Obj=new Random(); int IDValue = rnd.Next(1 500); //It will generate a random value from 1 to 500 and store it in variable and assign that value in the query as follows.you can modify as per your requirement. Select Question from Quiz where QuestionId=IDValue I hope it will resolve your problem. Reference - http://msdn.microsoft.com/en-us/library/2dx6wyd4.aspx