Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL2000 ASP.NET VB.NET
dear sir/ma'am

i have created a quiz site .sir all things works well but one problem i found that i want to fetch questions randomly in my question list how can i do it sir
help me
 
how can i achiw=eve the goal to fetch questions randomly for each student let i have 5 question then all questions are shown to every student but randomly

 
sir how this query can be written correctly
SELECT *
FROM Quizquestion
WHERE (Quiz_Id = '1417')
ORDER BY ques_id RAND()

 
random quesid fetch

my get question code is
str = "select * from quizdetails where quiz_id = '" & quizid & "'"
cmdly.rst1 = New DataTable
cmdly.rst1 = cmdly.executenonquery(str)
 
 
str = "select TOP 1 ques_id, question, correctoption, Quiz_Id from quizquestion where quiz_id = '" & quizid & "' ORDER BY NEWID()"
cmdly.rst2 = New DataTable
cmdly.rst2 = cmdly.executenonquery(str)
If cmdly.rst2.Rows.Count > 0 Then
 
lbquescnt.Text = quesid
lbques.Text = "Q. " & cmdly.rst2.Rows(0).Item("question").ToString
 
cmdly.rst3 = New DataTable
str = "select * from quizoption where quiz_id = '" & quizid & "' and ques_id = '" & cmdly.rst2.Rows(0).Item("ques_id") & "'"
cmdly.rst3 = cmdly.executenonquery(str)
 
If cmdly.rst3.Rows.Count > 0 Then
i = cmdly.rst3.Rows.Count
c = 0
quizlst.Items.Clear()
 
While c < i
Dim qlist As New System.Web.UI.WebControls.ListItem
qlist.Text = cmdly.rst3.Rows(c).Item("optionVALUE").ToString
qlist.Value = cmdly.rst3.Rows(c).Item("option_id").ToString
quizlst.Items.Add(qlist)
c = c + 1
End While
End If
End If
Posted 27-Jun-13 2:17am
ankur7891.4K
Edited 27-Jun-13 2:23am
gvprabu7.8K
v2
Comments
ThePhantomUpvoter at 27-Jun-13 7:19am
   
"fetch questions randomly in my question list how can i do it sir", the exact same way you have already been told.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Your question has already been answered here[^]
  Permalink  
Comments
Maciej Los at 27-Jun-13 17:38pm
   
Of course, +5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web04 | 2.8.1411022.1 | Last Updated 28 Jun 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100