[Solved] Accessing a RadGrid within a RadGrids ItemTemplate

[Chris Salas]

I am trying to export two different rad grids on one excel file.  I followed an example I found posed in the formums but am having issues acessing the radgrids that are inside of the itemtemplate of the RadGrid i want to export.  I have the following ASPX code:

 

<telerik:RadGrid ID="telerikBatchExportGrid" runat="server">
                            <MasterTableView>
                                <ItemTemplate>
                                    <telerik:RadGrid ID="telerikTransBatchGrid" runat="server" AutoGenerateColumns="false"
                                        AllowFilteringByColumn="true" AllowSorting="true" AllowPaging="true" Skin="BlueGrid"
                                        EnableEmbeddedSkins="false" AllowMultiRowSelection="false" Width="570px" PagerStyle-AlwaysVisible="true"
                                        ShowFooter="true" OnNeedDataSource="telerikTransBatchGrid_NeedDataSource" OnInit="telerikTransBatchGrid_Init">
                                        <PagerStyle Mode="NextPrevAndNumeric" />
                                        <GroupingSettings CaseSensitive="False" />
                                        <MasterTableView Width="570px">
                                            <Columns>
                                                <telerik:GridBoundColumn DataField="TrackingNumber" HeaderText="Tracking #" UniqueName="TrackingNumber" />
                                                <telerik:GridBoundColumn DataField="IndividualName" HtmlEncode="false" HeaderText="Name"
                                                    ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="center" />
                                                <telerik:GridBoundColumn DataField="EffectiveDate" HtmlEncode="false" HeaderText="Orig Date"
                                                    ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="center" DataFormatString="{0:d}"
                                                    FilterControlWidth="50px" />
                                                <telerik:GridBoundColumn DataField="Status" HtmlEncode="false" HeaderText="Status"
                                                    UniqueName="Status" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="center">
                                                    <FilterTemplate>
                                                        <telerik:RadScriptBlock ID="RadScriptsBlockStatus" runat="server">

                                                            <script type="text/javascript">
                                                    function StatusSelectedIndexChanged2(sender, args) {
                                                        var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");
                                                        tableView.filter("Status", args.get_item().get_value(), "EqualTo");
                                                    }
                                                            </script>

                                                        </telerik:RadScriptBlock>
                                                        <telerik:RadComboBox ID="telerikDDLStatusFilter" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Status").CurrentFilterValue %>'
                                                            runat="server" OnClientSelectedIndexChanged="StatusSelectedIndexChanged2" Width="85px">
                                                            <Items>
                                                                <telerik:RadComboBoxItem Text="All" Value="" />
                                                                <telerik:RadComboBoxItem Text="Pending" Value="Pending" />
                                                                <telerik:RadComboBoxItem Text="Sent" Value="Sent" />
                                                                <telerik:RadComboBoxItem Text="Funded" Value="Funded" />
                                                                <telerik:RadComboBoxItem Text="Failed" Value="Failed" />
                                                                <telerik:RadComboBoxItem Text="Approved" Value="Approved" />
                                                                <telerik:RadComboBoxItem Text="Refunded" Value="Refunded" />
                                                                <telerik:RadComboBoxItem Text="Reversal Requested" Value="Reversal Requested" />
                                                                <telerik:RadComboBoxItem Text="Reversal Complete" Value="Reversal Complete" />
                                                            </Items>
                                                        </telerik:RadComboBox>
                                                    </FilterTemplate>
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="Amount" HtmlEncode="false" HeaderText="Amount"
                                                    UniqueName="Amount" ItemStyle-HorizontalAlign="right" HeaderStyle-HorizontalAlign="center"
                                                    DataFormatString="{0:C}" Aggregate="sum" FooterStyle-HorizontalAlign="right"
                                                    FilterControlWidth="50px" FooterStyle-Font-Bold="true">
                                                </telerik:GridBoundColumn>
                                            </Columns>
                                        </MasterTableView>
                                    </telerik:RadGrid>
                                    <br />
                                    <h3>
                                        Client Transactions</h3>
                                    <telerik:RadGrid ID="telerikClientTransBatchGrid" runat="server" AutoGenerateColumns="false"
                                        AllowFilteringByColumn="true" AllowSorting="true" AllowPaging="true" Skin="BlueGrid"
                                        EnableEmbeddedSkins="false" AllowMultiRowSelection="false" Width="570px" PagerStyle-AlwaysVisible="true"
                                        ShowFooter="true" OnNeedDataSource="telerikClientTransBatchGrid_NeedDataSource" OnInit="telerikClientTransBatchGrid_Init">
                                        <PagerStyle Mode="NextPrevAndNumeric" />
                                        <GroupingSettings CaseSensitive="False" />
                                        <MasterTableView Width="570px">
                                            <Columns>
                                                <telerik:GridBoundColumn DataField="TrackingNumber" HeaderText="Tracking #" UniqueName="TrackingNumber">
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="IndividualName" HtmlEncode="false" HeaderText="Name"
                                                    ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="center" />
                                                <telerik:GridBoundColumn DataField="LogDate" HtmlEncode="false" HeaderText="Orig Date"
                                                    ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="center" DataFormatString="{0:d}"
                                                    FilterControlWidth="50px" />
                                                <telerik:GridBoundColumn DataField="Status" HtmlEncode="false" HeaderText="Status"
                                                    UniqueName="Status" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="center">
                                                    <FilterTemplate>
                                                        <telerik:RadScriptBlock ID="RadScriptsBlockClientStatus" runat="server">

                                                            <script type="text/javascript">
                                                    function StatusSelectedIndexChanged3(sender, args) {
                                                        var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");
                                                        tableView.filter("Status", args.get_item().get_value(), "EqualTo");
                                                    }
                                                            </script>

                                                        </telerik:RadScriptBlock>
                                                        <telerik:RadComboBox ID="telerikDDLStatusFilter" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Status").CurrentFilterValue %>'
                                                            runat="server" OnClientSelectedIndexChanged="StatusSelectedIndexChanged3" Width="85px">
                                                            <Items>
                                                                <telerik:RadComboBoxItem Text="All" Value="" />
                                                                <telerik:RadComboBoxItem Text="Pending" Value="Pending" />
                                                                <telerik:RadComboBoxItem Text="Sent" Value="Sent" />
                                                                <telerik:RadComboBoxItem Text="Funded" Value="Funded" />
                                                                <telerik:RadComboBoxItem Text="Failed" Value="Failed" />
                                                            </Items>
                                                        </telerik:RadComboBox>
                                                    </FilterTemplate>
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="Amount" HtmlEncode="false" HeaderText="Amount"
                                                    UniqueName="Amount" ItemStyle-HorizontalAlign="right" HeaderStyle-HorizontalAlign="center"
                                                    DataFormatString="{0:C}" Aggregate="sum" FooterStyle-HorizontalAlign="right"
                                                    FilterControlWidth="50px" FooterStyle-Font-Bold="true">
                                                </telerik:GridBoundColumn>
                                            </Columns>
                                        </MasterTableView>
                                    </telerik:RadGrid>
                                </ItemTemplate>
                            </MasterTableView>
                        </telerik:RadGrid>\

 

How do I access the internal RadGrids? I have tried the following with no sucess

CType(Me.telerikBatchExportGrid.MasterTableView.FindControl("telerikTransBatchGrid"), Telerik.Web.UI.RadGrid)
CType(Me.telerikBatchExportGrid.MasterTableView.Items(0).FindControl("telerikTransBatchGrid"), Telerik.Web.UI.RadGrid)

 

 

 

 

 

[Princy]

Hello Chris,

Since your main grid(telerikBatchExportGrid) is not bound to a source, the items are not created. Hence, you will not be able to access the nested controls. Try accessing the nested grids after binding your grid to a table as shown below:

c#:

protected void telerikBatchExportGrid_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
    {
        DataTable table = new DataTable();
        table.Columns.Add("Column");
        table.Rows.Add("");
        telerikBatchExportGrid.DataSource = table;
    }

Hope this makes sense.
Princy.

[Chris Salas]

Princy,

That worked perfectly.  Thanks for a quick response.

Chris

[Abdul]

Hi,

   how can i clear the rad grid items and set the rad grid to its initial state.

[Princy]

Hi,

In order to clear all the items from the grid ,you can set the datasource of the RadGrid to an empty object  array as shown below:

C#

RadGrid1.DataSource = new object[] { };

Princy.

[Margret]

Hi,
I am having a grid(radgridchild) inside item template of another grid(radgridparent).How can i set the visible property of radgridchild in the pageload event?

[Princy]

Hi,

Try the following code.
C#:

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
        foreach (GridDataItem item in RadGrid1.Items)
        {
            RadGrid grid = (RadGrid)item.FindControl("RadGrid2");
            grid.Visible = false;
       }
}

Thanks,
Princy

[Margret]

Thanks for a  quick response.
I have an another doubt with same condition.I have 3 tabs. And I have 3 grids inside a item template of another grid.
Based on the tab selected, I have to bind the dataset values for each grid respectively.How can i do this?

[Princy]

Hi,

Try the following code.
C#:

protected void RadTabStrip1_TabClick(object sender, RadTabStripEventArgs e)
    {
        RadTabStrip tab = (RadTabStrip)sender;
         foreach (GridDataItem item in RadGrid1.Items)
        {
            if (tab.SelectedTab.Text == "tab1")
            {
                RadGrid grid = (RadGrid)item.FindControl("RadGrid2");
               //populate grid here
            }
           else if (tab.SelectedTab.Text == "tab2")
            {
                RadGrid grid = (RadGrid)item.FindControl("RadGrid3");
                  //populate grid here
            }
        }
     }

Thanks,
Princy

[Margret]

Hi,
I have tried the exporting to excel for multiple grids.I have an combo box having values of Radgrid1,Radgrid2,Radgrid3,All grids.I have wrapped them in radgrid named Radwrapper.I f i choose radgrid1  or radgrid 3 it is exporting correctly.If i choose Allgrids means, it says "Object reference not set to an instance of an object" error.What wiil be the issue?
Thanks
Margret

[Princy]

Hi,

Try the approach mentioned in the following code library.
Export multiple RadGrids in single PDF/Excel file

Thanks,
Princy

[Margret]

Hi,
I have used the example as you told above.while exporting multigrids values ,if i choose allgrids in combo box,the excel contains data.I have set true for ignore paging.But the paging is not ignored for each grid values.what will be the reason for this?
Thanks
Margret.

[Margret]

Is there any update for this ?

[Andrey]

Hi,

Are you calling the Rebind() method after you set the IgnorePaging attribute? If you are dynamically changing the IgnorePaging attribute you will need to call the Rebind() method in order for the changes to take effect.

Regards,
Andrey
the Telerik team

[Margret]

Hi i have used the following code in button click event.After adding rebind() also, ignore paging is not worked in export to excel for multi grids.

 

 

 

 

 

protected void btn1_Click(object sender, EventArgs e)

{

 

RadGrid radGrid = RadComboBox1.SelectedItem.Text == "All RadGrids" ? RadGridWrapper : (RadGrid)RadGridWrapper.Items[0].FindControl(RadComboBox1.SelectedItem.Text);

radGrid.ExportSettings.FileName =

"Details1";

radGrid.ExportSettings.ExportOnlyData=

true;

 radGrid.ExportSettings.IgnorePaging = true;

 radGrid.ExportSettings.OpenInNewWindow = true;

radGrid.MasterTableView.ExportToExcel();

radGrid.Rebind();

}

 

 

Still i didnt have the data (in all pages) in excel sheet for multiple grids.Only the first page of data is exported for each grid.

[Andrey]

Hi,

Try to move the Rebind() method call to be before the ExportToExcel method. Otherwise the changes will be applied after you export the file and they will not be applied in the exported file.

Greetings,
Andrey
the Telerik team

[Margret]

Hi, Thanks for your response.
I  called  the rebind() method before the export to excel function.But still the other page values are not exported.If it is exporting grid1 only, it is working fine.But for multigrids it is exporting only first pages of the grids.
What will be the reason?

[Margret]

Hi, any update on this?

[Andrey]

Hi,

There should be no problem with the approach. The problem might come if you call the Rebind method before the IgnorePaging attribute is set to true. Your code should look as follows:

protected void btn1_Click(object sender, EventArgs e)
{
    RadGrid radGrid = RadComboBox1.SelectedItem.Text == "All RadGrids" ? RadGridWrapper : (RadGrid)RadGridWrapper.Items[0].FindControl(RadComboBox1.SelectedItem.Text);
    radGrid.ExportSettings.FileName ="Details1";
    radGrid.ExportSettings.ExportOnlyData=  true;
    radGrid.ExportSettings.IgnorePaging = true;
    radGrid.ExportSettings.OpenInNewWindow = true;
    radGrid.Rebind();
    radGrid.MasterTableView.ExportToExcel();
}

If this does not help, please open a formal support ticket and attach a sample project that replicates the issue.

Regards,
Andrey
the Telerik team