SELECT * FROM Quizquestion WHERE (Quiz_Id = '1417') ORDER BY ques_id RAND()
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)