I have a gridview that is pulling data from a database, in the gridview i have 3 radio buttons per row - once the grid is populated, I want to retrieve data from another table to select the radiobuttons that have been previously selected by the user - sometimes the user may not have made any selections so all radio buttons will be unselected.
this is my gridview so far
<asp:GridView ID="gvSchedule" runat="server" AutoGenerateColumns="False
" DataSourceID="SqlDataSourc
e1" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:RadioButton ID="AwayTeam" runat="server" GroupName="teamGroup" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Schedule_id" HeaderText="Schedule_id" InsertVisible="False"
ReadOnly="True" SortExpression="Schedule_i
d" Visible="False" />
<asp:ImageField DataImageUrlField="Away_Im
age" ReadOnly="True">
</asp:ImageField>
<asp:BoundField DataField="AWAY_TEAM_NAME"
HeaderText="Away Team" SortExpression="AWAY_TEAM_
NAME" />
<asp:TemplateField>
<ItemTemplate>
<asp:RadioButton ID="TieTeam" runat="server" GroupName="teamGroup" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="HOME_TEAM_NAME"
HeaderText="Home Team" SortExpression="HOME_TEAM_
NAME" />
<asp:ImageField DataImageUrlField="Home_Im
age" ReadOnly="True">
</asp:ImageField>
<asp:TemplateField>
<ItemTemplate>
<asp:RadioButton ID="HomeTeam" runat="server" GroupName="teamGroup" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Personal
%>"
SelectCommand="GetSchedule
" SelectCommandType="StoredP
rocedure" UpdateCommand="InsertPicks
" UpdateCommandType="StoredP
rocedure">
<SelectParameters>
<asp:ControlParameter ControlID="lblStartDate" DefaultValue="1/1/1900" Name="SCHEDULE_START_DATE"
PropertyName="Text" Type="DateTime" />
<asp:ControlParameter ControlID="lblEnddate" DefaultValue="1/1/1900" Name="SCHEDULE_END_DATE"
PropertyName="Text" Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
Start Free Trial