Hierarchy grid view on more than 2 levels not working

2 posts, 0 answers
  1. Minh Kevin
    Minh Kevin avatar
    5 posts
    Member since:
    Jun 2013

    Posted 01 Oct 2013 Link to this post

    Hi,

    i'm currently trying to do a hierarchy grid view on more than 2 levels and it isn't working.

    The grid is working fine if I use two levels but as soon as i add another one the expand on the grid show nothing after the second level

    Here's the code of the grid : 

    <telerik:RadGrid ID="rg_VL" runat="server"
            DataSourceID="SqlDataSourceCODPRO1"
            AllowSorting="True" AllowMultiRowSelection="False" AllowPaging="False" GridLines="None">
            <MasterTableView AutoGenerateColumns="false" DataSourceID="SqlDataSourceCODPRO1" DataKeyNames="CODPRO1">
                <DetailTables>
                            <telerik:GridTableView DataKeyNames="CODPRO2" DataSourceID="SqlDataSourceCODPRO2" runat="server">
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="CODPRO1" MasterKeyField="CODPRO1" />
                            </ParentTableRelation>
                            <DetailTables>
                                                            <telerik:GridTableView DataKeyNames="CODPRO3" DataSourceID="SqlDataSourceCODPRO3" runat="server">
                                                            <ParentTableRelation>
                                                                <telerik:GridRelationFields DetailKeyField="CODPRO2" MasterKeyField="CODPRO2" />
                                                            </ParentTableRelation>
                                                            <DetailTables>
                                                                                            <telerik:GridTableView DataKeyNames="CODPRO4" DataSourceID="SqlDataSourceCODPRO4" runat="server">
                                                                                                <ParentTableRelation>
                                                                                                    <telerik:GridRelationFields DetailKeyField="CODPRO3" MasterKeyField="CODPRO3" />
                                                                                                </ParentTableRelation>
                                                                                                <DetailTables>
                                                                                                                            <telerik:GridTableView DataKeyNames="CODPRO5" DataSourceID="SqlDataSourceCODPRO5" runat="server">
                                                                                                                                <ParentTableRelation>
                                                                                                                                    <telerik:GridRelationFields DetailKeyField="CODPRO4" MasterKeyField="CODPRO4" />
                                                                                                                                </ParentTableRelation>
                                                                                                                                <Columns>
                                                                                                                                    <telerik:GridBoundColumn SortExpression="CODPRO5" HeaderText="CODPRO5" HeaderButtonType="TextButton"
                                                                                                                                        DataField="CODPRO5" UniqueName="CODPRO5">
                                                                                                                                    </telerik:GridBoundColumn>
                                                                                                                                </Columns>
                                                                                                                            </telerik:GridTableView>
                                                                                                </DetailTables>
                                                                                                <Columns>
                                                                                                    <telerik:GridBoundColumn SortExpression="CODPRO4" HeaderText="CODPRO4" HeaderButtonType="TextButton"
                                                                                                        DataField="CODPRO4" UniqueName="CODPRO4">
                                                                                                    </telerik:GridBoundColumn>
                                                                                                </Columns>
                                                                                            </telerik:GridTableView>
                                                            </DetailTables>
                                                                <Columns>
                                                                    <telerik:GridBoundColumn SortExpression="CODPRO3" HeaderText="CODPRO3" HeaderButtonType="TextButton"
                                                                        DataField="CODPRO3" UniqueName="CODPRO3">
                                                                    </telerik:GridBoundColumn>
                                                                </Columns>
                                                                <SortExpressions>
                                                                    <telerik:GridSortExpression FieldName="CODPRO3"></telerik:GridSortExpression>
                                                                </SortExpressions>
                                                            </telerik:GridTableView>
                            </DetailTables>
                                <Columns>
                                    <%--<telerik:GridBoundColumn SortExpression="CODPRO2" HeaderText="CODPRO2" HeaderButtonType="TextButton"
                                        DataField="CODPRO2" UniqueName="CODPRO2">
                                    </telerik:GridBoundColumn>--%>
                                </Columns>
                                <SortExpressions>
                                    <telerik:GridSortExpression FieldName="CODPRO2"></telerik:GridSortExpression>
                                </SortExpressions>
                            </telerik:GridTableView>
                </DetailTables>
                <Columns>
                    <telerik:GridBoundColumn SortExpression="CODPRO1" HeaderText="CODPRO1" HeaderButtonType="TextButton"
                        DataField="CODPRO1" UniqueName="CODPRO1">
                    </telerik:GridBoundColumn>
                </Columns>
                <SortExpressions>
                    <telerik:GridSortExpression FieldName="CODPRO1"></telerik:GridSortExpression>
                </SortExpressions>
            </MasterTableView>
        </telerik:RadGrid>


    And the code of my datasources :

    <asp:SqlDataSource ID="SqlDataSourceCODPRO1" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>"
        ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO1 FROM VENTES_LACH_REG ORDER BY CODPRO1"
        runat="server">
    </asp:SqlDataSource>
         
    <asp:SqlDataSource ID="SqlDataSourceCODPRO2" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>"
        ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO2 FROM VENTES_LACH_REG Where CODPRO1 = :CODPRO1"
        runat="server">
        <SelectParameters>
            <asp:SessionParameter Name="CODPRO1" SessionField="CODPRO1" Type="string">
            </asp:SessionParameter>
        </SelectParameters>
    </asp:SqlDataSource>
     
    <asp:SqlDataSource ID="SqlDataSourceCODPRO3" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>"
        ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO3 FROM VENTES_LACH_REG CODPRO1 = :CODPRO1 AND CODPRO2 = :CODPRO2"
        runat="server">
        <SelectParameters>
            <asp:SessionParameter Name="CODPRO1" SessionField="CODPRO1" Type="string">
            </asp:SessionParameter>
            <asp:SessionParameter Name="CODPRO2" SessionField="CODPRO2" Type="string">
            </asp:SessionParameter>
        </SelectParameters>
    </asp:SqlDataSource>
     
    <asp:SqlDataSource ID="SqlDataSourceCODPRO4" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>"
        ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO4 FROM VENTES_LACH_REG WHERE CODPRO1 = :CODPRO1 AND CODPRO2 = :CODPRO2 AND CODPRO3 = :CODPRO3"
        runat="server">
        <SelectParameters>
            <asp:SessionParameter Name="CODPRO1" SessionField="CODPRO1" Type="string">
            </asp:SessionParameter>
            <asp:SessionParameter Name="CODPRO2" SessionField="CODPRO2" Type="string">
            </asp:SessionParameter>
            <asp:SessionParameter Name="CODPRO3" SessionField="CODPRO3" Type="string">
            </asp:SessionParameter>
        </SelectParameters>
    </asp:SqlDataSource>
     
    <asp:SqlDataSource ID="SqlDataSourceCODPRO5" ConnectionString="<%$ ConnectionStrings:bddBigJimWeb %>"
        ProviderName="System.Data.OracleClient" SelectCommand="SELECT DISTINCT CODPRO5 FROM VENTES_LACH_REG WHERE CODPRO1 = :CODPRO1 AND CODPRO2 = :CODPRO2 AND CODPRO3 = :CODPRO3 AND CODPRO4 = :CODPRO4"
        runat="server">
        <SelectParameters>
            <asp:SessionParameter Name="CODPRO1" SessionField="CODPRO1" Type="string">
            </asp:SessionParameter>
            <asp:SessionParameter Name="CODPRO2" SessionField="CODPRO2" Type="string">
            </asp:SessionParameter>
            <asp:SessionParameter Name="CODPRO3" SessionField="CODPRO3" Type="string">
            </asp:SessionParameter>
            <asp:SessionParameter Name="CODPRO4" SessionField="CODPRO4" Type="string">
            </asp:SessionParameter>
        </SelectParameters>
    </asp:SqlDataSource>


    Do you know why I have no errors shown on my web page but no hirarchical level after the second level ?

    Regards
  2. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 07 Oct 2013 Link to this post

    Hello Minh,

    I would suggest you to review the online demo below which elaborates on settings more than one level hierarchy:
    http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/threelevel/defaultcs.aspx

    Regards,
    Maria Ilieva
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Back to Top