Hi, I'm a programmer, but new to ASP.NET. I'm playing around with the
Repeater and DataGrid controls. Here's the situation. I've got a MySQL
database containing a couple tables. One called "games", one called "picks".
picks has fields "GameID", and "PickedTeam". games has fields "GameID",
"HomeTeam", and "AwayTeam". I what to be able to display all the data in the
games database in a table on a webpage with the user being able to select who
he or she thinks will win that game. I want to use radio buttons so the user
can only choose one team per row. Then when the user has choosen a winner for
each game (or row) he or she clicks the "Sumbit" button. What needs to happen
now is that for each row, an entry is entered into the picks table. The
GameID and PickedTeam are entered. I'm not going to worry about any of the
validation yet until I have this working. The idea I have in my head is to
have a RadioButtonList for each row. The ID will be the GameID field pulled
from the database. Each RadioButton in the list's name will just be the name
of the team pulled from the database. Then when one team is choosen from each
row, what can be entered in the picks database is a bunch of rows based on
the name of the RadioButtonList and the value choosen in that List. This is
probably not a difficult problem for someone who really knows the controls
well and knows how to use them. Any feedback is really appreciated. Thanks!
