I used DevExpress.XtraTreeList.TreeList component to show tree structured DB table on a form. It was so easy.
create table treesamp (
nodeid number(5),
parentnodeid number(5),
datatext varchar2(50)
);
Sample table data:
1 0 "Root"
2 1 "Leaf 1"
3 1 "Leaf 2"
4 2 "Leaf 1 of Leaf 1"
5 2 "Leaf 2 of Leaf 1"
6 3 "Leaf 1 of Leaf 2"
7 3 "Leaf 2 of Leaf 2"
8 4 "Leaf 1 of Leaf 1 of Leaf 1"
...
Place your TreeList on a form and just set following values:
treelist1.DataSource= treeDataTable;
treelist1.KeyFieldName= "nodeid";
treelist1.ParentFieldName= "parentid";
treelist1.PreviewFieldName= "datatext";
RootValue= 0; // if id of parent is zero, it must be root node
To print the tree treeList1.ShowPrintPreview();
It prints it in XtraReport Preview, the same as in form grid.
Showing posts with label tree structure. Show all posts
Showing posts with label tree structure. Show all posts
Thursday, May 29, 2008
Tree in a datagrid
Labels:
datagrid,
datatable,
devx,
tree structure,
TreeList
Subscribe to:
Comments (Atom)