I have a radgrid control with 2 radiobuttonlist. The user will select the radiobuttonlists for all rows of the radgrid and then hit a submit button. What I would like to do is loop through each row of the grid and find out which radio button was selected for each of the 2 radiobuttonlist and then read the value of the pid column from that row, then fire a sql update statement to update the database according to the pid and radiobutton selected. Can someone shed some light on how to do this? Thanks in advance.
<telerik:RadGrid ID="RgdPub" runat="server"
AutoGenerateColumns="false" DataSourceID="SqlRgdPub" Skin="Web20" AllowSorting="true">
<FilterMenu EnableImageSprites="False">
</FilterMenu>
<ClientSettings>
<Selecting CellSelectionMode="None" />
</ClientSettings>
<MasterTableView CommandItemDisplay="Top" GridLines="Both" Width="100%" AllowSorting="true" >
<CommandItemSettings ShowAddNewRecordButton="false"
ShowExportToCsvButton="true" ShowExportToExcelButton="true"
ShowExportToPdfButton="false" ShowExportToWordButton="true" />
<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"
Visible="True">
</RowIndicatorColumn>
<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"
Visible="True">
</ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn HeaderText="Is this your publication?" UniqueName="Pub">
<ItemTemplate>
<asp:RadioButtonList ID="RblPub" runat="server" RepeatColumns=2 RepeatDirection="Horizontal">
<asp:ListItem Text="Yes" Value=1></asp:ListItem>
<asp:ListItem Text="No" Value=0></asp:ListItem>
</asp:RadioButtonList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Is this institute supported?" UniqueName="InsPub">
<ItemTemplate>
<asp:RadioButtonList ID="RblInsPub" runat="server" RepeatColumns=2 RepeatDirection="Horizontal">
<asp:ListItem Text="Yes" Value=1></asp:ListItem>
<asp:ListItem Text="No" Value=0></asp:ListItem>
</asp:RadioButtonList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn UniqueName="lastname" EditFormColumnIndex="0" HeaderText="Last Name"
DataField="lastname">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="firstname" EditFormColumnIndex="0" HeaderText="First Name"
DataField="firstname">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="institution" EditFormColumnIndex="0" HeaderText="Institution"
DataField="institution">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="pid" EditFormColumnIndex="0" HeaderText="PID"
DataField="pid">
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column">
</EditColumn>
</EditFormSettings>
</MasterTableView>
</telerik:RadGrid>
<telerik:RadGrid ID="RgdPub" runat="server"
AutoGenerateColumns="false" DataSourceID="SqlRgdPub" Skin="Web20" AllowSorting="true">
<FilterMenu EnableImageSprites="False">
</FilterMenu>
<ClientSettings>
<Selecting CellSelectionMode="None" />
</ClientSettings>
<MasterTableView CommandItemDisplay="Top" GridLines="Both" Width="100%" AllowSorting="true" >
<CommandItemSettings ShowAddNewRecordButton="false"
ShowExportToCsvButton="true" ShowExportToExcelButton="true"
ShowExportToPdfButton="false" ShowExportToWordButton="true" />
<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"
Visible="True">
</RowIndicatorColumn>
<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"
Visible="True">
</ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn HeaderText="Is this your publication?" UniqueName="Pub">
<ItemTemplate>
<asp:RadioButtonList ID="RblPub" runat="server" RepeatColumns=2 RepeatDirection="Horizontal">
<asp:ListItem Text="Yes" Value=1></asp:ListItem>
<asp:ListItem Text="No" Value=0></asp:ListItem>
</asp:RadioButtonList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Is this institute supported?" UniqueName="InsPub">
<ItemTemplate>
<asp:RadioButtonList ID="RblInsPub" runat="server" RepeatColumns=2 RepeatDirection="Horizontal">
<asp:ListItem Text="Yes" Value=1></asp:ListItem>
<asp:ListItem Text="No" Value=0></asp:ListItem>
</asp:RadioButtonList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn UniqueName="lastname" EditFormColumnIndex="0" HeaderText="Last Name"
DataField="lastname">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="firstname" EditFormColumnIndex="0" HeaderText="First Name"
DataField="firstname">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="institution" EditFormColumnIndex="0" HeaderText="Institution"
DataField="institution">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="pid" EditFormColumnIndex="0" HeaderText="PID"
DataField="pid">
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column">
</EditColumn>
</EditFormSettings>
</MasterTableView>
</telerik:RadGrid>