我如何将数据随机绑定到一个单选按钮列表

本文关键字：一个 列表 单选按钮 数据 绑定 随机 | 更新日期: 2023-09-27 18:09:50

我正在构建一个表单。我需要在radiobuttonlist中显示我的问题，然后显示3个答案[它们是同一表中的列]。

我尝试将数据自动绑定到Datalist。

然后检查如果正确的答案被选中…如果不是，我需要显示一个错误

<asp:DataList ID="DataList1t" runat="server" DataSourceID="AccessDataSource1" onitemdatabound="DataList1_ItemDataBound" onselectedindexchanged="DataList1t_SelectedIndexChanged1">
    <ItemTemplate>
        <table>
            <tr>
                <td>
                    <%# Eval("TheQus") %>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:RadioButtonList runat="server" ID="RadioButtonList1">
                    </asp:RadioButtonList>
                </td>
            </tr>
        </table>
        <br />
        <br />
    </ItemTemplate>
</asp:DataList>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/Databasegeometreyeh.accdb" SelectCommand="SELECT TOP 4 Qus.ID, Qus.TheQus, Qus.CorrectAns, Qus.Ans2, Qus.Ans3 FROM  EkhtbrNafsk INNER JOIN Qus ON EkhtbrNafsk.ID = Qus.Type  WHERE  Qus.Type= 1  order By rnd(Qus.ID)"></asp:AccessDataSource>

后面的代码是

protected void Page_Load(object sender, EventArgs e)
{
    //DataList1t.Visible = false;
    //DataTable QusTri = DAL.SelectFromTable("SELECT TOP 4 Qus.TheQus FROM  EkhtbrNafsk INNER JOIN Qus ON EkhtbrNafsk.ID = Qus.Type  WHERE  Qus.Type=" + 1 + " order By rnd(Qus.ID)");
    //DataList1t.DataSource = QusTri;
    //DataList1t.DataBind();
    //DataList1r.Visible = false;
    //DataTable Qusrepoe = DAL.SelectFromTable("SELECT TOP 4 Qus.TheQus FROM  EkhtbrNafsk INNER JOIN Qus ON EkhtbrNafsk.ID = Qus.Type  WHERE Qus.Type= " + 2 + " order By rnd(Qus.ID)");
    //DataList1r.DataSource = Qusrepoe;
    //DataList1r.DataBind();

    if (!IsPostBack)
    {
        DataTable t1 = DAL.SelectFromTable("select * from [EkhtbrNafsk]");
        DropDownList1.DataTextField = "TypeTest";
        DropDownList1.DataValueField = "ID";
        DropDownList1.DataSource = t1;
        DropDownList1.DataBind();
        DataList1t.Visible = false;
        DataList1r.Visible = false;
    }
}
protected void Button2_Click(object sender, EventArgs e)
{
    if (DropDownList1.SelectedValue == "1")
    {
        DataList1t.Visible = true;
    }
    else if (DropDownList1.SelectedValue == "2")
        DataList1r.Visible = true;
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
    if (e.Item.ItemType == ListItemType.Item)
    {
        RadioButtonList RadioButtonList1 = (RadioButtonList)e.Item.FindControl("RadioButtonList1");
        int QuestionID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "ID"));
        DataTable dt = DAL.SelectFromTable("SELECT Qus.ID, Qus.CorrectAns, Qus.Ans2, Qus.Ans3 FROM  EkhtbrNafsk INNER JOIN Qus ON EkhtbrNafsk.ID = Qus.Type  WHERE  Qus.ID=" + QuestionID);
        RadioButtonList1.Items.Add(dt.Rows[0][0].ToString());
        RadioButtonList1.Items.Add(dt.Rows[0][1].ToString());
        RadioButtonList1.Items.Add(dt.Rows[0][2].ToString());//Bind the RadiobUttonList here

    }
}

我如何将数据随机绑定到一个单选按钮列表

试试这个:

DataTable dt = DAL.SelectFromTable("SELECT Qus.ID, Qus.CorrectAns, Qus.Ans2, Qus.Ans3 FROM EkhtbrNafsk ORDER BY rand() INNER JOIN Qus ON EkhtbrNafsk.ID = Qus.Type  WHERE  Qus.ID=" + QuestionID );
相关文章：