Grid / Declarative Relations - Detail Not Showing

[Doug]

Hi,

I'm currently trying to create an example page using the RadGrid control.  I'm basing the demo on your own here, the only difference being that I'm only using a single detail level, instead of two.  Unfortunately though, I can't seem to get and detail rows to show up at all! When I click to expand the row, I get the column headings but no actual data.  The mark-up I'm using is as follows:

<telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0" DataSourceID="SqlDataSource1" GridLines="None" AutoGenerateColumns="False">
    <MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="JOB_ID" HierarchyLoadMode="ServerBind" AutoGenerateColumns="false">
        <DetailTables>
            <telerik:GridTableView DataSourceID="SqlDataSource2" Width="100%" runat="server" HierarchyLoadMode="ServerBind" AutoGenerateColumns="false">
                <ParentTableRelation>
                    <telerik:GridRelationFields DetailKeyField="JOB_ID" MasterKeyField="JOB_ID" />
                </ParentTableRelation>
                <Columns>
                    <telerik:GridBoundColumn SortExpression="SET_TIME" HeaderText="SET_TIME" HeaderButtonType="TextButton" DataField="SET_TIME" UniqueName="SET_TIME" />
                    <telerik:GridBoundColumn SortExpression="NODE_NAME" HeaderText="NODE_NAME" HeaderButtonType="TextButton" DataField="NODE_NAME" UniqueName="NODE_NAME" />
                </Columns>
            </telerik:GridTableView>
        </DetailTables>
        <Columns>                    
            <telerik:GridBoundColumn SortExpression="JOB_ID" HeaderText="JOB_ID" HeaderButtonType="TextButton" DataField="JOB_ID" UniqueName="JOB_ID" />
            <telerik:GridBoundColumn SortExpression="PROCESS_NAME" HeaderText="PROCESS_NAME" HeaderButtonType="TextButton" DataField="PROCESS_NAME" UniqueName="PROCESS_NAME" />                    
        </Columns>
    </MasterTableView>            
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
    SelectCommand="SELECT [JOB_ID], [PROCESS_NAME] FROM [JOB]">
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
    SelectCommand="SELECT [SET_TIME], [NODE_NAME] FROM [JOB_HISTORY] WHERE ([JOB_ID] = @JOB_ID)">
    <SelectParameters>
        <asp:SessionParameter Name="JOB_ID" SessionField="JOB_ID" Type="Object" />
    </SelectParameters>
</asp:SqlDataSource>

Thanks for your help.

[Princy]

Hello,

Try setting DataKeyNames property in GridTableView of  DetailTables.

Thanks,
Princy.