how to generate random data into database

Question

i make quiz application not generate question randomaly . not generate NEXT click to next question retrive same question.

Imtiyaz Ansari · Answer

try... you use C# Random function get question by Random id wise.... private static readonly Random random = new Random(); private static double RandomNumberBetween(double minValue double maxValue) { var next = random.NextDouble(); return minValue + (next * (maxValue - minValue)); }

maniyar mustafa · Answer

Thanks but another problem is there. I retrieve data from table but not all question are retrieve and store into database

Imtiyaz Ansari · Answer

Hi mustafa I think can you select random question simply your problem resolve. Ex. SELECT TOP 1 column FROM table ORDER BY NEWID() every time fetch different question.