Detail data display no data in a simple hierarchical grid

[Dave]

Hello Guys,

I have a strange issue on a simple hierarchical grid. When I click on a row to expand on detailed rows, it shows nothing even there are data in the DB, can somebody help me to find out where the problem is? Here is my code;

<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage2.master" AutoEventWireup="false" CodeFile="Local_HRs_PersonnalMovements.aspx.vb" Inherits="Local_HRs_Local_HRs_PersonnalMovements" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Main" Runat="Server">
    <asp:SqlDataSource ID="SDS_Employees" runat="server"
        ConflictDetection="CompareAllValues"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        DeleteCommand="DELETE FROM db_owner.[MDE_Employees] WHERE [EmployeeID] = @original_EmployeeID AND (([GlobeID] = @original_GlobeID) OR ([GlobeID] IS NULL AND @original_GlobeID IS NULL)) AND [FirstName] = @original_FirstName AND [LastName] = @original_LastName AND [Birthdate] = @original_Birthdate AND [GenderID] = @original_GenderID AND (([Initials] = @original_Initials) OR ([Initials] IS NULL AND @original_Initials IS NULL))"
        InsertCommand="INSERT INTO db_owner.MDE_GlobeEmployeeIDs (GlobeEmployeeID) VALUES (@GlobeID);INSERT INTO db_owner.[MDE_Employees] ([GlobeID], [FirstName], [LastName], [Birthdate], [GenderID], [Initials]) VALUES (@GlobeID, @FirstName, @LastName, @Birthdate, @GenderID, @Initials)"
        OldValuesParameterFormatString="original_{0}"
        SelectCommand="SELECT [EmployeeID], [GlobeID], [FirstName], [LastName], [Birthdate], [GenderID], [Initials] FROM db_owner.[MDE_Employees]"


        UpdateCommand="UPDATE db_owner.[MDE_Employees] SET [GlobeID] = @GlobeID, [FirstName] = @FirstName, [LastName] = @LastName, [Birthdate] = @Birthdate, [GenderID] = @GenderID, [Initials] = @Initials WHERE [EmployeeID] = @original_EmployeeID AND (([GlobeID] = @original_GlobeID) OR ([GlobeID] IS NULL AND @original_GlobeID IS NULL)) AND [FirstName] = @original_FirstName AND [LastName] = @original_LastName AND [Birthdate] = @original_Birthdate AND [GenderID] = @original_GenderID AND (([Initials] = @original_Initials) OR ([Initials] IS NULL AND @original_Initials IS NULL))">
        <DeleteParameters>
            <asp:Parameter Name="original_EmployeeID" Type="Int32" />
            <asp:Parameter Name="original_GlobeID" Type="Int32" />
            <asp:Parameter Name="original_FirstName" Type="String" />
            <asp:Parameter Name="original_LastName" Type="String" />
            <asp:Parameter Name="original_Birthdate" Type="DateTime" />
            <asp:Parameter Name="original_GenderID" Type="Int32" />
            <asp:Parameter Name="original_Initials" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="GlobeID" Type="Int32" />
            <asp:Parameter Name="FirstName" Type="String" />
            <asp:Parameter Name="LastName" Type="String" />
            <asp:Parameter Name="Birthdate" Type="DateTime" />
            <asp:Parameter Name="GenderID" Type="Int32" />
            <asp:Parameter Name="Initials" Type="String" />
            <asp:Parameter Name="original_EmployeeID" Type="Int32" />
            <asp:Parameter Name="original_GlobeID" Type="Int32" />
            <asp:Parameter Name="original_FirstName" Type="String" />
            <asp:Parameter Name="original_LastName" Type="String" />
            <asp:Parameter Name="original_Birthdate" Type="DateTime" />
            <asp:Parameter Name="original_GenderID" Type="Int32" />
            <asp:Parameter Name="original_Initials" Type="String" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="GlobeID" Type="Int32" />
            <asp:Parameter Name="FirstName" Type="String" />
            <asp:Parameter Name="LastName" Type="String" />
            <asp:Parameter Name="Birthdate" Type="DateTime" />
            <asp:Parameter Name="GenderID" Type="Int32" />
            <asp:Parameter Name="Initials" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SDS_Positions" runat="server"
        ConflictDetection="CompareAllValues"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        DeleteCommand="DELETE FROM db_owner.[TRE_Positions] WHERE [PositionID] = @original_PositionID AND [EmployeeID] = @original_EmployeeID AND [StatusID] = @original_StatusID AND [WorkContractID] = @original_WorkContractID AND [StartDate] = @original_StartDate AND (([EndDate] = @original_EndDate) OR ([EndDate] IS NULL AND @original_EndDate IS NULL)) AND [OrgUnitID] = @original_OrgUnitID AND [GroupingID] = @original_GroupingID AND [SubGroupingID] = @original_SubGroupingID AND [WorkRate] = @original_WorkRate AND [TransferReasonID] = @original_TransferReasonID"
        InsertCommand="INSERT INTO db_owner.[TRE_Positions] ([EmployeeID], [StatusID], [WorkContractID], [StartDate], [EndDate], [OrgUnitID], [GroupingID], [SubGroupingID], [WorkRate], [TransferReasonID]) VALUES (@EmployeeID, @StatusID, @WorkContractID, @StartDate, @EndDate, @OrgUnitID, @GroupingID, @SubGroupingID, @WorkRate, @TransferReasonID)"
        OldValuesParameterFormatString="original_{0}"
        SelectCommand="SELECT [PositionID], [EmployeeID], [StatusID], [WorkContractID], [StartDate], [EndDate], [OrgUnitID], [GroupingID], [SubGroupingID], [WorkRate], [TransferReasonID] FROM db_owner.[TRE_Positions] WHERE ([EmployeeID] = @EmployeeID)"


        UpdateCommand="UPDATE db_owner.[TRE_Positions] SET [EmployeeID] = @EmployeeID, [StatusID] = @StatusID, [WorkContractID] = @WorkContractID, [StartDate] = @StartDate, [EndDate] = @EndDate, [OrgUnitID] = @OrgUnitID, [GroupingID] = @GroupingID, [SubGroupingID] = @SubGroupingID, [WorkRate] = @WorkRate, [TransferReasonID] = @TransferReasonID WHERE [PositionID] = @original_PositionID AND [EmployeeID] = @original_EmployeeID AND [StatusID] = @original_StatusID AND [WorkContractID] = @original_WorkContractID AND [StartDate] = @original_StartDate AND (([EndDate] = @original_EndDate) OR ([EndDate] IS NULL AND @original_EndDate IS NULL)) AND [OrgUnitID] = @original_OrgUnitID AND [GroupingID] = @original_GroupingID AND [SubGroupingID] = @original_SubGroupingID AND [WorkRate] = @original_WorkRate AND [TransferReasonID] = @original_TransferReasonID">
        <SelectParameters>
            <asp:SessionParameter Name="EmployeeID" SessionField="EmployeeID" Type="Int32" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="original_PositionID" Type="Int32" />
            <asp:Parameter Name="original_EmployeeID" Type="Int32" />
            <asp:Parameter Name="original_StatusID" Type="Int32" />
            <asp:Parameter Name="original_WorkContractID" Type="Int32" />
            <asp:Parameter Name="original_StartDate" Type="DateTime" />
            <asp:Parameter Name="original_EndDate" Type="DateTime" />
            <asp:Parameter Name="original_OrgUnitID" Type="Int32" />
            <asp:Parameter Name="original_GroupingID" Type="Int32" />
            <asp:Parameter Name="original_SubGroupingID" Type="Int32" />
            <asp:Parameter Name="original_WorkRate" Type="Int32" />
            <asp:Parameter Name="original_TransferReasonID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:SessionParameter Name="EmployeeID" SessionField="EmployeeID" Type="Int32" />
            <asp:Parameter Name="StatusID" Type="Int32" />
            <asp:Parameter Name="WorkContractID" Type="Int32" />
            <asp:Parameter Name="StartDate" Type="DateTime" />
            <asp:Parameter Name="EndDate" Type="DateTime" />
            <asp:Parameter Name="OrgUnitID" Type="Int32" />
            <asp:Parameter Name="GroupingID" Type="Int32" />
            <asp:Parameter Name="SubGroupingID" Type="Int32" />
            <asp:Parameter Name="WorkRate" Type="Int32" />
            <asp:Parameter Name="TransferReasonID" Type="Int32" />
            <asp:Parameter Name="original_PositionID" Type="Int32" />
            <asp:Parameter Name="original_EmployeeID" Type="Int32" />
            <asp:Parameter Name="original_StatusID" Type="Int32" />
            <asp:Parameter Name="original_WorkContractID" Type="Int32" />
            <asp:Parameter Name="original_StartDate" Type="DateTime" />
            <asp:Parameter Name="original_EndDate" Type="DateTime" />
            <asp:Parameter Name="original_OrgUnitID" Type="Int32" />
            <asp:Parameter Name="original_GroupingID" Type="Int32" />
            <asp:Parameter Name="original_SubGroupingID" Type="Int32" />
            <asp:Parameter Name="original_WorkRate" Type="Int32" />
            <asp:Parameter Name="original_TransferReasonID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:SessionParameter Name="EmployeeID" SessionField="EmployeeID" Type="Int32" />
            <asp:Parameter Name="StatusID" Type="Int32" />
            <asp:Parameter Name="WorkContractID" Type="Int32" />
            <asp:Parameter Name="StartDate" Type="DateTime" />
            <asp:Parameter Name="EndDate" Type="DateTime" />
            <asp:Parameter Name="OrgUnitID" Type="Int32" />
            <asp:Parameter Name="GroupingID" Type="Int32" />
            <asp:Parameter Name="SubGroupingID" Type="Int32" />
            <asp:Parameter Name="WorkRate" Type="Int32" />
            <asp:Parameter Name="TransferReasonID" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SDS_WorkContracts" runat="server"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        SelectCommand="SELECT [WorkContractID], [WorkContract] FROM db_owner.[MDE_WorkContracts]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SDS_OrgUnits" runat="server"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        SelectCommand="SELECT [ID], [OrgUnit] FROM db_owner.[MDO_OrgUnits]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SDS_Statuses" runat="server"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        SelectCommand="SELECT [StatusID], [Status] FROM db_owner.[MDE_Statuses]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SDS_Groupings" runat="server"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        SelectCommand="SELECT [GroupingID], [Grouping] FROM db_owner.[MDE_Groupings]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SDS_SubGroupings" runat="server"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        SelectCommand="SELECT [SubGroupingID], [SubGrouping] FROM db_owner.[MDE_SubGroupings]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SDS_TransferReasons" runat="server"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        SelectCommand="SELECT [TransferReasonID], [TransferReason] FROM db_owner.[MDE_TransferReasons]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SDS_Genders" runat="server"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        SelectCommand="SELECT [GenderID], [Gender] FROM db_owner.[MDE_Genders]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SDS_Languages" runat="server"
        ConnectionString="<%$ ConnectionStrings:DBCentreList %>"
        SelectCommand="SELECT [LanguageID], [Language] FROM db_owner.[MDE_Languages]"></asp:SqlDataSource>

<table width="99%" border="0">
    <tr>
        <td rowspan="2" valign="top" style="width:200px;">
            <telerik:RadPanelBar ID="RadPanelBar1" runat="server" Width="200px" ExpandMode="FullExpandedItem" Height="100%" Skin="Office2007">
                <Items>
                    <telerik:RadPanelItem runat="server" Text="Maintenance RHs" Expanded="true">
                        <Items>
                            <telerik:RadPanelItem runat="server" Text="Mouvements du Personnel" NavigateUrl="Local_HRs_PersonnalMovements.aspx" Selected="true">
                            </telerik:RadPanelItem>
                            <telerik:RadPanelItem runat="server" Text="Nestec FTEs Budget" NavigateUrl="Local_HRs_NestecBudgets.aspx"></telerik:RadPanelItem>
                        </Items>
                    </telerik:RadPanelItem>
                    <telerik:RadPanelItem runat="server" Text="Rapports RHs">
                        <Items>
                            <telerik:RadPanelItem runat="server" Text="FTEs Situation" NavigateUrl="Local_HRs_FTEsSituation.aspx"></telerik:RadPanelItem>
                            <telerik:RadPanelItem runat="server" Text="HRs External Budget" NavigateUrl="Local_HRs_ExternalBudgets.aspx"></telerik:RadPanelItem>
                            <telerik:RadPanelItem runat="server" Text="HRs Costing Report" NavigateUrl="Local_HRs_FTEsCostingReport.aspx"></telerik:RadPanelItem>
                        </Items>
                    </telerik:RadPanelItem>
                </Items>
            </telerik:RadPanelBar>
        </td>
        <td style="background-color:Navy; color:White; font-weight: bold; font-size: 12px; padding:10px; margin: 10px; text-align: center;">
            Mouvements du Personnel
        </td>
    </tr>
    <tr>
        <td>
    <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" Skin="Office2007"
        AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"
        DataSourceID="SDS_Employees" GridLines="None" Width="100%">
        <GroupingSettings CaseSensitive="false" />
<ExportSettings ExportOnlyData="True" IgnorePaging="True" HideStructureColumns="false">
    <Excel Format="Html" />
</ExportSettings>

<MasterTableView DataKeyNames="EmployeeID" DataSourceID="SDS_Employees" Width="100%" CommandItemDisplay="Top"
    AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" AutoGenerateColumns="false">
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
    <Columns>
        <telerik:GridBoundColumn DataField="EmployeeID" DataType="System.Int32"
            HeaderText="EmployeeID" ReadOnly="True" SortExpression="EmployeeID"
            UniqueName="EmployeeID" FilterControlWidth="30px" Visible="false">
            <ItemStyle Width="50px" />
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="GlobeID" DataType="System.Int32"
            HeaderText="GlobeID" SortExpression="GlobeID" UniqueName="GlobeID" FilterControlWidth="50px">
            <ItemStyle Width="70px" />
        </telerik:GridBoundColumn>
        <telerik:GridDropDownColumn SortExpression="GenderID" DataSourceID="SDS_Genders"
            DataField="GenderID" HeaderText="Gender" DropDownControlType="RadComboBox"
            ListTextField="Gender" ListValueField="GenderID" FilterControlWidth="50px">
            <ItemStyle Width="70px" />
        </telerik:GridDropDownColumn>
        <telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName"
            SortExpression="FirstName" UniqueName="FirstName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="LastName" HeaderText="LastName"
            SortExpression="LastName" UniqueName="LastName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Initials" DataType="System.String"
            HeaderText="REFs" SortExpression="Initials" UniqueName="Initials" FilterControlWidth="30px">
            <ItemStyle Width="50px" />
        </telerik:GridBoundColumn>
        <telerik:GridDateTimeColumn SortExpression="Birthdate" HeaderText="Birthdate" HeaderButtonType="TextButton"
            DataField="Birthdate" UniqueName="Birthdate" DataFormatString="{0:dd.MM.yyyy}" FilterControlWidth="50px">
            <ItemStyle Width="70px" />
        </telerik:GridDateTimeColumn>
    </Columns>
    <DetailTables>
        <telerik:GridTableView DataKeyNames="PositionID" AllowFilteringByColumn="False" DataSourceID="SDS_Positions" runat="server"
            CommandItemDisplay="Top" AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" Width="99%">
            <ParentTableRelation>
                <telerik:GridRelationFields DetailKeyField="EmployeeID" MasterKeyField="EmployeeID" />
            </ParentTableRelation>
            <SortExpressions>
                <telerik:GridSortExpression FieldName="StartDate" SortOrder="Descending" />
            </SortExpressions>
            <Columns>
                <telerik:GridBoundColumn DataField="PositionID" DataType="System.Int32"
                    HeaderText="PositionID" ReadOnly="True" SortExpression="PositionID"
                    UniqueName="PositionID" Visible="false">
                </telerik:GridBoundColumn>
                <telerik:GridDropDownColumn SortExpression="StatusID" DataSourceID="SDS_Statuses"
                    DataField="StatusID" HeaderText="Status" DropDownControlType="RadComboBox"
                    ListTextField="Status" ListValueField="StatusID">
                    <ItemStyle Width="60px" />
                </telerik:GridDropDownColumn>
                <telerik:GridDropDownColumn SortExpression="WorkContractID" DataSourceID="SDS_WorkContracts"
                    DataField="WorkContractID" HeaderText="Work Contract" DropDownControlType="RadComboBox"
                    ListTextField="WorkContract" ListValueField="WorkContractID">
                    <ItemStyle Width="80px" />
                </telerik:GridDropDownColumn>
                <telerik:GridDateTimeColumn SortExpression="StartDate" HeaderText="Start" HeaderButtonType="TextButton"
                    DataField="StartDate" UniqueName="StartDate" DataFormatString="{0:dd.MM.yyyy}">
                    <ItemStyle Width="80px" />
                </telerik:GridDateTimeColumn>
                <telerik:GridDateTimeColumn SortExpression="EndDate" HeaderText="End" HeaderButtonType="TextButton"
                    DataField="EndDate" UniqueName="EndDate" DataFormatString="{0:dd.MM.yyyy}">
                    <ItemStyle Width="80px" />
                </telerik:GridDateTimeColumn>
                <telerik:GridDropDownColumn SortExpression="OrgUnitID" DataSourceID="SDS_OrgUnits"
                    DataField="OrgUnitID" HeaderText="Org. Unit" DropDownControlType="RadComboBox"
                    ListTextField="OrgUnit" ListValueField="ID">
                </telerik:GridDropDownColumn>
                <telerik:GridDropDownColumn SortExpression="GroupingID" DataSourceID="SDS_Groupings"
                    DataField="GroupingID" HeaderText="Grouping" DropDownControlType="RadComboBox"
                    ListTextField="Grouping" ListValueField="GroupingID">
                    <ItemStyle Width="100px" />
                </telerik:GridDropDownColumn>
                <telerik:GridDropDownColumn SortExpression="SubGroupingID" DataSourceID="SDS_SubGroupings"
                    DataField="SubGroupingID" HeaderText="SubGrouping" DropDownControlType="RadComboBox"
                    ListTextField="SubGrouping" ListValueField="SubGroupingID">
                    <ItemStyle Width="150px" />
                </telerik:GridDropDownColumn>
                <telerik:GridDropDownColumn SortExpression="TransferReasonID" DataSourceID="SDS_TransferReasons"
                    DataField="TransferReasonID" HeaderText="Reason" DropDownControlType="RadComboBox"
                    ListTextField="TransferReason" ListValueField="TransferReasonID">
                    <ItemStyle Width="100px" />
                </telerik:GridDropDownColumn>
                <telerik:GridBoundColumn DataField="WorkRate" DataType="System.Int32"
                    HeaderText="WorkRate" SortExpression="WorkRate" UniqueName="WorkRate">
                    <ItemStyle Width="60px" />
                </telerik:GridBoundColumn>
            </Columns>
        </telerik:GridTableView>
    </DetailTables>
    <CommandItemSettings ShowExportToExcelButton="true" />
</MasterTableView>
    </telerik:RadGrid>
    </td>
    </tr>
    </table>
</asp:Content>

Wish someone can help on what seems to me to be a mistery, I have gone several times through the code without seeing any problem...

Thanks alot for your help,
David

[Shinu]

Hello David,

Please make sure that the  ParentTableRelation that you have set is correct. Take a look in to the following help article and demo for more on this.
Hierarchical data-binding using declarative relations.
Grid / Declarative Relations.

Thanks,
Shinu.

[Dave]

Hello Shinu,

Thank you for your answer. I did give it a try however the issue remains...
I may add that on a separate page, I have a RadGrid that is performing well...
 
Regards,
David

[Dave]

To add more precision on this stuff, I am using Framework 3.5...

[Marin]

Hello David,

 I see that you are using a session parameter as a select parameter for the detail table data source. This might cause problems if for some reason the session variable is not populated at the time the detail table is bound. You might try setting a default value for this parameter to see if this is the reason for the observed behavior.

Best wishes,
Marin
the Telerik team

[Dave]

Hi Marin,

Thank you for the post. I tried the following as suggested;

<SelectParameters>
  <asp:SessionParameter Name="EmployeeID" SessionField="EmployeeID" Type="Int32" DefaultValue="1" />
</SelectParameters>

But it is not fixing the problem... like something wrong with the databinding but I still cannot figure out what (see Screen shot attached)

Regards,
David

[Marin]

Hi David,

 Can you try setting the EmployeeID column to be visible and not readonly, to see of this makes a change.

<telerik:GridBoundColumn DataField="EmployeeID" DataType="System.Int32"
            HeaderText="EmployeeID" ReadOnly="False" SortExpression="EmployeeID"
            UniqueName="EmployeeID" FilterControlWidth="30px" Visible="true">

Greetings,
Marin
the Telerik team

[Dave]

Hi Marin,

I did it and got the same result (it worked once and when I closed and open a new session, it fails again, see print creen attached)

Regards,
David

[Marin]

Hi David,

 I tried to reproduce the issue using a stripped version of your sample code but to no avail. I am attaching the project that worked correctly on my side. Can you specify what changes are needed in order to replicate the issue or send us back a sample page that reproduces the problem.
In order to run the attached project you need to reference the correct Telerik.Web.UI assembly and change the connection string to correspond to your local SQL server instance.

Kind regards,
Marin
the Telerik team

[Dave]

Ok Guys,

After thorough tests, I've removed an entry in the web.config file;

<system.net>

    <mailSettings>

        <smtp from="[e-mail]">

            <network host="xxxxxx.xxxxxx.com" port="25" UserName="[e-mail]" password="myPassword" defaultCredentials="true"/>

        </smtp>

    </mailSettings>
...

Where the credential was deactivated in the AD.
Don't ask me why this mailSettings entry had an influence on the grid, I simply don't have any clue on it, but now it is fixed...

Thank you for your answers guys,
Enjoy your day !

David