Looping Through Rows in Rad Grid and saving

[Ryan]

I am new to .net and Telerik controls.

I am trying to do this technique, but using the radgrid.

http://msdn.microsoft.com/en-us/library/aa992036%28VS.80%29.aspx

However, I need to loop through each row in this grid and update with the selected values.

Any help or ideas would be great.

    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:AR_ManagementConnectionString %>"
        SelectCommand="SELECT * FROM [AR_QA_Details] WHERE (([iUserID] = @iUserID) AND ([sSiteID] = @sSiteID) AND ([sAcct] = @sAcct) AND ([IssueName] = @IssueName)) ORDER BY [StepNumber]">
        <SelectParameters>
            <asp:Parameter DefaultValue="111" Name="iUserID" Type="Int32" />
            <asp:Parameter DefaultValue="108002" Name="sSiteID" Type="String" />
            <asp:Parameter DefaultValue="295856" Name="sAcct" Type="String" />
            <asp:Parameter DefaultValue="Coding" Name="IssueName" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>




    <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1"
        GridLines="None">
<MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>


    <Columns>
        <telerik:GridBoundColumn DataField="Step" HeaderText="Step"
            SortExpression="Step" UniqueName="Step">
            <HeaderStyle Width="350px" />
        </telerik:GridBoundColumn>
        <telerik:GridTemplateColumn DataField="Critical" DataType="System.Int32"
            HeaderText="Critical" SortExpression="Critical" UniqueName="Critical">
            <EditItemTemplate>
                <asp:TextBox ID="CriticalTextBox" runat="server" Text='<%# Bind("Critical") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:CheckBox ID="CriticalCheckBox" runat="server" Checked='<%# Eval("Critical") %>' />
            </ItemTemplate>
            <FooterStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
                Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
                Wrap="True" />
            <HeaderStyle Width="50px" Font-Bold="False" Font-Italic="False"
                Font-Overline="False" Font-Strikeout="False" Font-Underline="False"
                HorizontalAlign="Center" Wrap="True" />
            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
                Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
                Wrap="True" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="Pass" DataType="System.Int32"
            HeaderText="Pass" SortExpression="Pass" UniqueName="Pass">
            <EditItemTemplate>
                <asp:TextBox ID="PassTextBox" runat="server" Text='<%# Bind("Pass") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:RadioButton ID="PassRadioButton" GroupName="PassFailNA" runat="server" Checked='<%# Eval("Pass") %>' />
            </ItemTemplate>
            <FooterStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
                Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
                Wrap="True" />
            <HeaderStyle Width="50px" Font-Bold="False" Font-Italic="False"
                Font-Overline="False" Font-Strikeout="False" Font-Underline="False"
                HorizontalAlign="Center" Wrap="True" />
            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
                Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
                Wrap="True" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="Fail" DataType="System.Int32"
            HeaderText="Fail" SortExpression="Fail" UniqueName="Fail">
            <EditItemTemplate>
                <asp:TextBox ID="FailTextBox" runat="server" Text='<%# Bind("Fail") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:RadioButton ID="FailRadioButton" GroupName="PassFailNA" runat="server" Checked='<%# Eval("Fail") %>' />
            </ItemTemplate>
            <FooterStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
                Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
                Wrap="True" />
            <HeaderStyle Width="50px" Font-Bold="False" Font-Italic="False"
                Font-Overline="False" Font-Strikeout="False" Font-Underline="False"
                HorizontalAlign="Center" Wrap="True" />
            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
                Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
                Wrap="True" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="NA" DataType="System.Int32"
            HeaderText="NA" SortExpression="NA" UniqueName="NA">
            <EditItemTemplate>
                <asp:TextBox ID="NATextBox" runat="server" Text='<%# Bind("NA") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:RadioButton ID="NARadioButton" GroupName="PassFailNA" runat="server" Checked='<%# Eval("NA") %>' />
            </ItemTemplate>
            <FooterStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
                Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
                Wrap="True" />
            <HeaderStyle Width="50px" Font-Bold="False" Font-Italic="False"
                Font-Overline="False" Font-Strikeout="False" Font-Underline="False"
                HorizontalAlign="Center" Wrap="True" />
            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"
                Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
                Wrap="True" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="Notes" HeaderText="Notes"
            SortExpression="Notes" UniqueName="Notes">
            <EditItemTemplate>
                <asp:TextBox ID="NotesTextBox" runat="server" Text='<%# Bind("Notes") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:TextBox ID="NotesTextBox" runat="server" TextMode="Multiline"  Rows="2" Columns="50" Text='<%# Bind("Notes") %>'></asp:TextBox>
            </ItemTemplate>
        </telerik:GridTemplateColumn>
    </Columns>
</MasterTableView>
    </telerik:RadGrid>
    <asp:Button ID="SaveButton" runat="server" Text="Save" />

[Jayesh Goyani]


// if item in edit mode

foreach (GridDataItem item in RadGrid1.EditItems)

{

    GridEditableItem item = (GridEditableItem)item.EditFormItem;

    string ID = item.GetDataKeyValue("ID").ToString();

    TextBox  CriticalTextBox = (TextBox)item.FindControl("CriticalTextBox");

     // your db code

}

  

// item is not in edit mode

foreach (GridDataItem item in RadGrid1.Items)

{

    string ID = item.GetDataKeyValue("ID").ToString();

    CheckBox CriticalCheckBox = (CheckBox)item.FindControl("CriticalCheckBox");

   // your db code

}

Thanks,
Jayesh Goyani

[Ryan]

This loops through the grid, but bombs on 

string ID = item.GetDataKeyValue("ID").ToString();

Should this be a specific field?

[Jayesh Goyani]

<MasterTableView DataKeyNames="ID">

for more information of DataKeyNames
http://www.telerik.com/help/aspnet-ajax/p_telerik_web_ui_gridtableview_datakeynames.html

Thanks,
Jayesh Goyani