Data Binding - Build Tree from Plain Data


 DepartmentBudgetLocationPhone1Phone2
[Collapse]Corporate Headquarters$1,000,000.00Monterey(408) 555-1234(408) 555-1234
 [Collapse]Sales and Marketing$22,000.00San Francisco(415) 555-1234(415) 555-1234
   Field Office: Canada$500,000.00Toronto(416) 677-1000(416) 555-1234
   Field Office: East Coast$500,000.00Boston(617) 555-4234(415) 555-1234
  [Expand]Pacific Rim Headquarters$600,000.00Kuaui(808) 555-1234(808) 555-1234
   Marketing$1,500,000.00San Francisco(415) 555-1234(415) 555-1234
  Finance$40,000.00Monterey(408) 555-1234(408) 555-1234
 [Collapse]Engineering$1,100,000.00Monterey(408) 555-1234(408) 555-1234
  [Expand]Consumer Electronics Div.$1,150,000.00Burlington, VT(802) 555-1234(802) 555-1234
  [Expand]Software Products Div.$1,200,000.00Monterey(408) 555-1234(408) 555-1234
Description
C#
VB
ASPX

This demo shows how to bind the 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.