Multiple Radio Button List in Repeater Control

[CURTISLESPERANCE]

Hi, I am trying to figure out if this is possible. I need to display 4 radio buttons next to a question then 3 radio buttons after. The 2 different group radio buttons and questions are coming from a database.

I have the questions being displayed right now using a repeater control but I am having an issue making 4 and 3 radio buttins per question for multiple questions. However some questions have sub questions so the parent question doesn't have the radio buttons. Is this possible?

E.G.
- radio|radio|rad io|radio|questi on|radio|radio| radio

- question

- radio|radio|rad io|radio|Sub question|radio| radio|radio

[nateraaaa]

Hi, I am trying to figure out if this is possible. I need to display 4 radio buttons next to a question then 3 radio buttons after. The 2 different group radio buttons and questions are coming from a database.

I have the questions being displayed right now using a repeater control but I am having an issue making 4 and 3 radio buttins per question for multiple questions. However some questions have sub questions so the parent question doesn't have the radio buttons. Is this possible?

E.G.
- radio|radio|rad io|radio|questi on|radio|radio| radio

- question

- radio|radio|rad io|radio|Sub question|radio| radio|radio

This is possible. You need to figure out the logic to make this work. I believe whatever code you write will need to be in the repeaters ItemDataBound event. This way you can identify what to display (question or question - sub question).

Nathan

[CURTISLESPERANCE]

Ya, that's the key, what is the logic to it, what do I need to use to make this happen?

[Frinavale]

Ya, that's the key, what is the logic to it, what do I need to use to make this happen?

You need to implement this logic when you are retrieving the questions from your database.

[CURTISLESPERANCE]

I'm not sure you guys understand, so here is my code. and I need to display radio buttons for all parent questions unless it has a child question

Page code:

<table width="100%" cellpadding="0" cellspacing="0" border="0">
    <asp:Repeater runat="server" ID="RepWorkArea" OnItemDataBound="ShowQuestions">
        <ItemTemplate>
            <tr>
                <td colspan="3">
                    <h4><%# ((DataRowView)Container.DataItem)["WorkArea"]%></h4>
                </td>
            </tr>
            <asp:Repeater ID="RepQuestions" OnItemDataBound="ShowSubQuestions" runat="server">
                <itemtemplate> 
                <tr>
                    <td width="90px"><asp:RadioButtonList ID="radQuestionList" runat="server" DataSourceID="SqlDataSource1" DataValueField="SkillImportanceID" OnSelectedIndexChanged="btnViewSkill_Click" RepeatDirection="Horizontal" DataTextField="empty" RepeatLayout="flow"/></td>
                    <td width="*"><b><%# (Container.ItemIndex + 1) %>.</b> <%# ((DataRowView)Container.DataItem)["Question"]%></td>
                    <td width="70px" align="right"><asp:RadioButtonList ID="radSubQuestionList" runat="server" DataSourceID="SqlDataSource2" DataValueField="AnswerID" RepeatDirection="Horizontal" DataTextField="empty" RepeatLayout="flow"/></td>
                </tr>
                <tr>
                    <td colspan="3" align="left">
                        <table width="100%"  cellpadding="0" cellspacing="0" border="0">
                            <asp:repeater id="RepSubQuestions" runat="server"> 
                                <itemtemplate>
                                <tr>
                                    <td width="90px">
                                        <asp:RadioButtonList ID="radQuestionList" runat="server" DataSourceID="SqlDataSource1" DataValueField="SkillImportanceID" OnSelectedIndexChanged="btnViewSkill_Click" RepeatDirection="Horizontal" DataTextField="empty" RepeatLayout="flow"/>
                                    </td>
                                    <td width="*">
                                        <div id="SubQuestions">
                                            <li class="bold"><%# DataBinder.Eval(Container.DataItem, "[\"Question\"]")%></li>
                                        </div>
                                    </td>
                                    <td width="70px" align="right">
                                        <asp:RadioButtonList ID="radSubQuestionList" runat="server" DataSourceID="SqlDataSource2" DataValueField="AnswerID" RepeatDirection="Horizontal" DataTextField="empty" RepeatLayout="flow"/>
                                    </td>
                                </tr>
                                </itemtemplate> 
                            </asp:repeater>   
                        </table>
                    </td>
                </tr>
                </itemtemplate> 
            </asp:Repeater>
        </ItemTemplate>
    </asp:Repeater>
</table>
 

//Code Behind

private SqlConnection connString = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString());
 
    protected void Page_Load(object sender, EventArgs e)
    {
        string strSql;
        DataSet ds = new DataSet();
        strSql = "select distinct A.* from WorkAreas as A right Join EvaluationQuestions AS B on a.WorkAreaId = B.WorkAreaID AND B.EvaluationID = 1 Order By A.SortOrder";
        SqlDataAdapter daWorkAreas = new SqlDataAdapter(strSql, connString);
        daWorkAreas.Fill(ds, "WorkAreas");
        strSql = "select * from EvaluationQuestions WHERE ParentId = -1 AND Active = 1 AND EvaluationID = 1 Order By EvaluationQuestionID";
        SqlDataAdapter daEvaluationQuestions = new SqlDataAdapter(strSql, connString);
        daEvaluationQuestions.Fill(ds, "EvaluationQuestions");
        strSql = "select * from EvaluationQuestions WHERE Active = 1 AND EvaluationID = 1 Order By EvaluationQuestionID";
        SqlDataAdapter daSubQuestions = new SqlDataAdapter(strSql, connString);
        daSubQuestions.Fill(ds, "SubQuestions");
        DataRelation rel = new DataRelation("QuestionsRel",ds.Tables["WorkAreas"].Columns["WorkAreaID"], ds.Tables["EvaluationQuestions"].Columns["WorkAreaID"],false);
        ds.Relations.Add(rel);
        DataRelation rel2 = new DataRelation("QuestionsRel2", ds.Tables["EvaluationQuestions"].Columns["EvaluationQuestionID"], ds.Tables["SubQuestions"].Columns["ParentID"], false);
        ds.Relations.Add(rel2);
        RepWorkArea.DataSource = ds.Tables["WorkAreas"].DefaultView;
        RepWorkArea.DataBind();
        connString.Close();
 
    }
 
    public void ShowQuestions(Object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            ((Repeater)e.Item.FindControl("RepQuestions")).DataSource =
            ((DataRowView)e.Item.DataItem).CreateChildView("QuestionsRel");
            ((Repeater)e.Item.FindControl("RepQuestions")).DataBind();
        }
    }
 
    public void ShowSubQuestions(Object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            ((Repeater)e.Item.FindControl("RepSubQuestions")).DataSource =
            ((DataRowView)e.Item.DataItem).CreateChildView("QuestionsRel2");
            ((Repeater)e.Item.FindControl("RepSubQuestions")).DataBind();
        }
    }