Multiple tables at one level, hierarchy model

This example represents a custom interaction with the Telerik RadGrid hierarchy model.

You can have more than one table in a hierarchy level. The tables that reside in the same level should be declared in the DetailTables collection of their parent table. Furthermore, to display several tables at one level in hierarchical grid, you will need to set appropriate ParentTableRelations for the parent/child tables included in the corresponding relation.
Then you only need to generate the datasources for the detail tables and bind them in the NeedDataSource event. Similar solution can be implemented in the DetailTableDataBind handler of the grid.

Note that hierarchical structure is not supported with simple data-binding (calling DataBind()). See the Simple data binding demo from the Populating with data section for more info about the limitations of this binding mode.

You can review this chapter from the grid help for further reference:
Several tables at a level

	RadGrid
	1Overview 2Outlook grid 3Web grid 4Business grid 5Web Mail Grid 6Migration from MS GridView Columns 7Column types 8Column formatting 9Column/Row/Grid resize/reorder Rows 10Normal/Alternating rows 11Selected rows style 12Accessing cells and rows 13Auto postback on row click Populating with Data 14Simple data-binding 15Advanced data-binding 16Hierarchy with declarative relations 17Hierarchy with DetailTableDataBind event 18Self-referencing hierarchy 19Related grids 20Various data sources 21Programmatic creation from XML 22Heavy data load/viewstate optimization 23Displaying pivot data Sorting 24Basic sorting 25Advanced sorting Paging 26Basic paging 27Alphabetic pager 28Slider/Advanced-style pager 29Pager template 30Customizing the pager programmatically 31Custom paging 32SEO-friendly paging Scrolling 33Basic scrolling 34Virtual scrolling and paging 35Frozen columns Selecting 36Client-side row selection 37Server-side row selection Exporting 38MS Excel/MS Word/CSV 39Export to PDF AJAX 40AJAX RadGrid 41Loading template 42AJAXifying standard controls 43AJAX request events 44JavaScript after AJAX 45Triggering an AJAX call outside of the grid Filtering 46Basic filtering 47Filtering in hierarchy 48Filtering template columns Hierarchy 49Three-level hierarchy 50Several tables at a level 51Client-side hierarchy loading 52Mixed hierarchy loading Grouping 53Outlook-style grouping 54Group-By expressions 55Client group load Insert/Update/Delete 56Automatic operations Extracting values 57Using column editors 58Using grid server-side API for extraction 59Auto-generated edit form with multiple columns 60Command item 61User control edit form 62Form template edit form 63Edit on double-click 64Client-side delete 65Editing XML using XmlDataSource Validation 66Flexible server-side validation Programmatic creation 67On PageInit 68On PageLoad 69Creating hierarchy programmatically Appearance 70Skins 71Styling Header, Footer and Pager items 72Styling edited rows 73Right to left support Client-Side API and Events 74Client objects and events 75Client-side API 76Keys/Values client-side Accessibility 77Keyboard support Integration 78File Browser 79Updating RadGrid with a WebService 80Grid Filtered by Combo 81Google-like Filtering 82LoadOnDemand Grid in Combo 83Window Editing 84Ajax-enabled context menu 85Custom Editors 86Resizing RadGrid in RadSplitter 87RadUpload and RadGrid 88RadNumericTextBox for RadGrid footer totals 89RadChart in RadGrid column 90RadGrid and aggregate RadChart

Demos

Several tables at a level