Create multiple RadioButtonLists in ASP.NET from a single table in SQL Server using C#

Question

I would like to use ASP.net, C# and SQL to display a list of games with radio buttons like below (the x is the radio). One team can be selected for each game.

game 1:   x team 4   x team 2
game 2:   x team 6   x team 1
game 3:   x team 5   x team 3

The game list is stored in a table in an SQL database. So far, I can pull all teams into one big RadioButtonList. I cannot figure out how to create multiple RadioButtonList controls from this single table of games. Does anyone know how this can be accomplished - or reference to an example / tutorial that accomplishes something like this?

Raymund · Accepted Answer · 2010-11-11 01:09:45Z

2

Use a listview for the different games and radiobuttonlist for the items

like such

<asp:ListView ID="ListView1" runat="server" onitemdatabound="ListView1_ItemDataBound">
    <ItemTemplate>
        <asp:Label runat="server" ID="txtGame" Text='<%# Bind("GameName") %>'></asp:Label><br />
        <asp:HiddenField ID="hdnGameID" runat="server" Value='<%# Bind("GameID") %>'/>
        <asp:RadioButtonList runat="server" ID="rblTeam" DataTextField="TeamName" DataValueField="TeamID">
        </asp:RadioButtonList>
    </ItemTemplate>
</asp:ListView>

then on your code behind

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        var oGame = from g in myDB.Game
                    group g by g.GameName into result
                    select new { GameID = result.Key, GameName = result };

        ListView1.DataSource = oGame;
        ListView1.DataBind();
    }
}

protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)
{
    HiddenField hdnGameID = (HiddenField)e.Item.FindControl("hdnGameID");
    RadioButtonList rblTeam = (RadioButtonList)e.Item.FindControl("rblTeam");

    var oTeam = from t in myDB.Game
                where t.GameID == hdnGameID.Value
                select t;

    rblTeam.DataSource = oTeam;
    rblTeam.DataBind();
}

edited Nov 11, 2010 at 1:09

answered Nov 11, 2010 at 0:33

Raymund

7,9125 gold badges50 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

drquinn Over a year ago

Seems like that should work, but still doesn't address how I get the games in the SQL table separated. I am new to all of this so hopefully I'm just missing something simple here...

drquinn Over a year ago

Yes 1 table. I see you added some code, I'm checking it out now. It would need to load 2 teams per RadioButtonList, right?

Raymund Over a year ago

Answer updated. I assumed that you use a table name Game so I used Game Table only and grouped the listview data by GameName

Collectives™ on Stack Overflow

Create multiple RadioButtonLists in ASP.NET from a single table in SQL Server using C#

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related