Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

Build Tree from Plain Data

CollapseCorporate Headquarters$1,000,000.00Monterey(408) 555-1234
 CollapseSales and Marketing$22,000.00San Francisco(415) 555-1234
   Field Office: Canada$500,000.00Toronto(416) 677-1000
   Field Office: East Coast$500,000.00Boston(617) 555-4234
  ExpandPacific Rim Headquarters$600,000.00Kuaui(808) 555-1234
   Marketing$1,500,000.00San Francisco(415) 555-1234
  Finance$40,000.00Monterey(408) 555-1234
 CollapseEngineering$1,100,000.00Monterey(408) 555-1234
  ExpandConsumer Electronics Div.$1,150,000.00Burlington, VT(802) 555-1234
  ExpandSoftware Products Div.$1,200,000.00Monterey(408) 555-1234

This demo shows how to bind the DevExpress ASP.NET Tree List (ASPxTreeList) control to an MS Access database. Since the ASPxTreeList is designed to display information in a tree structure, its data source should meet certain requirements. Two additional fields are necessary to build a tree structure.

The first field must contain unique values. This field must be assigned to the KeyFieldName property. The second field must contain values that indicate parent nodes for the current node. It should be assigned to the ParentFieldName property. Columns bound to these fields are called Service columns.

In this demo, toggle the Show service columns check box to display or hide service columns.

Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxTreeListDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxTreeListDemos