随机取问题 [英] random fetch questions

问题描述

亲爱的先生/女士



i已经创建了一个测验网站.sir所有的东西都很好但是我发现有一个问题我想在我的网站上随机取问题问题列表我怎么能这样做先生

帮助我



我怎么能achiw = eve为每个学生随机取问题的目标让我有5个问题然后所有问题都显示给每个学生但是随机地





先生如何正确地写这个查询

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

推荐答案

您可以尝试通过NEWID（）从

You can try "select * from tblTableName order by NEWID()"

使用Random clase生成随机问题编号，然后使用此编号来获取问题。以下样本在1-20之间生成10个随机数。在你的情况下使用qustion银行中可用的问题数量。

Use Random clase to generate the random question numbers and then use this number to fetch question. The below sample generated 10 random number between 1-20. In your case use the count of questions available in qustion bank.

Random r = new Random();
for (int i = 0; i < 10; i++)
{
      int x= r.Next(20);
      MessageBox.Show( x.ToString());
}

请参阅本页的最后一个示例：SQL - RAND函数 [ ^ ]。

See the final example in this page: "SQL - RAND Function"[^].

这篇关于随机取问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！