Issues with NestedViewSettings

[marksweat]

I've got a Master Grid, with a NestedViewTemplate that has a sub grid in it. I want this sub grid to databind when a row in the Master Grid is expanded. The sub grid's binding method needs the data key from the Master Grid row to bind. I'm having trouble connecting this key to the sub grid, its always 0. I've reviewed the documention for NestedViewTemplates and NestedViewSettings but must still be doing something wrong. The docs for the NestViewTemplates refer to the working demo but it uses a Label to stash the Master Table row key rather than the NestedViewSettings which I'm trying to use. I've have been able to bind the sub grid table using various techniques such as stashing the Master Table row key in the label or using NeedsDataSource. These other methods won't work for me as they want to bind sub grid data for all rows of the master grid when the page is loaded and this is too slow.

 

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" Runat="Server">
     <telerik:RadScriptManager ID="BudgetAdjustmentScriptManager" runat="server" EnablePartialRendering="true"></telerik:RadScriptManager>

         <telerik:RadGrid ID="BudgetAdjustmentRadGrid" runat="server" Width="100%" AllowPaging="True" AllowSorting="true" AutoGenerateColumns="False" PageSize="20" DataSourceID="BugetAdjustmentRadGrid_ObjectDataSource" 
            AlternatingItemStyle-BackColor="#e6e6e6" ShowFooter="True">
            <MasterTableView CommandItemDisplay="Top" Width="100%" DataKeyNames="budget_adjustment_master_id" ShowGroupFooter="true" Name="Master">
                <Columns>
                    <telerik:GridEditCommandColumn ButtonType="FontIconButton" UniqueName="Edit"></telerik:GridEditCommandColumn>
                    <telerik:GridBoundColumn DataField="name" HeaderText="Name" UniqueName="name" MaxLength="50" ></telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="number" HeaderText="Number" UniqueName="number" readonly="true"></telerik:GridBoundColumn>
                </Columns>
                <NestedViewSettings DataSourceID="BudgetAdjustmentItem_ObjectDataSource">
                      <ParentTableRelation>
                        <telerik:GridRelationFields DetailKeyField="budget_adjustment_master_id" MasterKeyField="budget_adjustment_master_id"  />
                      </ParentTableRelation>
                </NestedViewSettings>
                <NestedViewTemplate>
                    <asp:Panel ID="InnerContainer" runat="server" CssClass="viewWrap" Visible="True">
                        <telerik:RadGrid ID="BudgetAdjustmentItemRadGrid" runat="server" DataSourceID="BudgetAdjustmentDetail_ObjectDataSource" AllowPaging="true" AllowSorting="true" AutoGenerateColumns="false" >
                                <MasterTableView DataKeyNames="budget_adjustment_master_id, budget_adjustment_detail_id" HierarchyLoadMode="ServerOnDemand" PageSize="10" CommandItemDisplay="Top">
                                <Columns>
                                    <telerik:GridEditCommandColumn ButtonType="FontIconButton" UniqueName="Edit"></telerik:GridEditCommandColumn>
                                    <telerik:GridBoundColumn DataField="budget_adjustment_detail_id" HeaderText="ID" SortExpression="budget_adjustment_detail_id" UniqueName="budget_adjustment_detail_id" ReadOnly="true"></telerik:GridBoundColumn> 
                                    <telerik:GridBoundColumn DataField="budget_adjustment_operation" HeaderText="Operation" SortExpression="budget_adjustment_operation" UniqueName="budget_adjustment_operation" ReadOnly="true"></telerik:GridBoundColumn> 
                                    </Columns>
                            </MasterTableView>
                        </telerik:RadGrid>

                    </asp:Panel>
                </NestedViewTemplate>
            </MasterTableView>
        </telerik:RadGrid>
                        <asp:ObjectDataSource ID="BudgetAdjustmentDetail_ObjectDataSource" runat="server" TypeName="BudgetAdjustmentDetailDAL" SelectMethod="Get" SortParameterName="sort_expression" >
                            <SelectParameters>
                                <asp:Parameter Name="budget_adjustment_master_id" Type="Int32" />
                                <asp:Parameter Name="project_node_master_id" DefaultValue="25" Type="Int32" />
                            </SelectParameters>
                        </asp:ObjectDataSource>
    <asp:ObjectDataSource ID="BudgetAdjustmentItem_ObjectDataSource" runat="server" TypeName="BudgetAdjustmentMasterDAL" SelectMethod="Get">
        <SelectParameters>
            <asp:Parameter Name="budget_adjustment_master_id" Type="Int32" />
        </SelectParameters>
    </asp:ObjectDataSource>
    <asp:ObjectDataSource ID="BugetAdjustmentRadGrid_ObjectDataSource" runat="server" TypeName="BudgetAdjustmentMasterDAL" SelectMethod="Get" SortParameterName="sort_expression">
        <SelectParameters>
            <asp:Parameter Name="project_node_master_id" DefaultValue="33" Type="Int32" />
        </SelectParameters>
    </asp:ObjectDataSource>
</asp:Content>

[Eyup]

Hello Mark,

The secret here is to set the Visible property of the InnerContainer Panel to false initially. This will prevent the rendering and binding of every inner grid. You can switch it to true only for the expanded rows:
http://demos.telerik.com/aspnet-ajax/grid/examples/hierarchy/hierarchy-with-templates/defaultcs.aspx

That should do the trick. I am also sending a sample RadGrid web site to demonstrate a programmatic way of binding for NestedViewTemplate.

Regards,
Eyup
Progress Telerik

[marksweat]

So you don't recommend the method I'm using for binding with the NestedViewSettings?

[marksweat]

I guess I have a lot of questions here.

1. Any idea why the NestedViewSetting setup I'm using in the above example isn't work?

2. How do you recommend communicating the data key of the Master Table row that is opened to the NestedTableView grid? Is NestedViewSetting not designed to do this? Why does the Telerik example mentioned above use a Label to communicate the data key?

3. Can you illuminate how the HierarchyLoadMode="ServerOnDemand" function work for the Sub Grid? For example, why is the setting ignored or doesn't work if the InnerContainer Panel is initially visible?

 

--Mark

[Konstantin Dikov]

Hello Mark,

Detailed information on this matter could be found in the following help article:

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/hierarchical-grid-types-and-load-modes/nestedview-template

Hope this helps.


Regards,
Konstantin Dikov
Progress Telerik