Self-Referencing Heirarcy Not Working

1 posts, 0 answers
  1. Digger
    Digger avatar
    6 posts
    Member since:
    Sep 2009

    Posted 16 Jun 2017 Link to this post

    Have data as follows:

    Column:  PrimaryKey: (Int32) ResourceId - not null

    Column: (Int32?) : ParentId - can be null.

    So top level ParentId fields for ResourceId's will be null.

    <SelfHierarchySettings KeyName="ResourceId" ParentKeyName="ParentId" />

    Do I have to use a NeedDataSource? Why?

    Spent hours trying to get a seemingly simple 5 minute exercise to get a self-referencing grid to work.  Paging is off.  Googled and Stack-Overflow for hours - nobody has had this problem?  Help Please ?

    Thanks..

    <telerik:RadGrid ID="RGHWTreeView" runat="server" DataSourceID="EDS_BARHW" Width="100%"
                            AllowSorting="True" ShowStatusBar="True" ShowFooter="True" ShowGroupPanel="True" AutoGenerateColumns="False" AllowPaging="False"
                            OnItemInserted="theGrid_ItemInserted" OnItemUpdated="theGrid_ItemUpdated" OnItemDeleted="theGrid_ItemDeleted" OnPreRender="theGrid_PreRender"
                            OnItemCreated="theGrid_ItemCreated" OnItemDataBound="theGrid_ItemDataBound" OnItemCommand="theGrid_ItemCommand"
                            AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateHierarchy="False"
                            CellSpacing="0" GridLines="None" EnableHeaderContextMenu="True" OnDeleteCommand="theGrid_DeleteCommand" OnEditCommand="theGrid_EditCommand" OnInsertCommand="theGrid_InsertCommand">
                            <ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True" ReorderColumnsOnClient="True" EnableRowHoverStyle="True" AllowColumnHide="True" AllowKeyboardNavigation="True" AllowRowHide="True" ColumnsReorderMethod="Reorder">
                                <DataBinding EnableCaching="False"></DataBinding>
                                <Selecting AllowRowSelect="True" />
                                <Scrolling AllowScroll="True" UseStaticHeaders="True" ScrollHeight="420px" />
                                <Resizing AllowColumnResize="True" AllowRowResize="True"></Resizing>
                                <Animation AllowColumnReorderAnimation="True"></Animation>
                            </ClientSettings>
                            <MasterTableView DataSourceID="EDS_BARHW" DataKeyNames="ResourceId,ParentId,Owner" CssClass="w3-tiny" Name="Hardware Detail: " Caption="HW Tree Detail"
                                AllowMultiColumnSorting="True" EnableHeaderContextAggregatesMenu="True" EnableHeaderContextFilterMenu="False"
                                CommandItemDisplay="Top" EditMode="EditForms" AllowFilteringByColumn="False"
                                AllowSorting="True" ShowHeadersWhenNoRecords="True" AllowPaging="False" PageSize="20">
                                <SelfHierarchySettings KeyName="ResourceId" ParentKeyName="ParentId" />
                                <CommandItemSettings AddNewRecordText="New Hardware Resource"
                                    ShowExportToCsvButton="True" ShowExportToExcelButton="True" ShowExportToWordButton="True" ShowAddNewRecordButton="True"></CommandItemSettings>
                                <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column" Visible="True"></RowIndicatorColumn>
                                <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>
                                <Columns>
Back to Top