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>