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.
Thursday, May 29, 2008
Tree in a datagrid
Labels:
datagrid,
datatable,
devx,
tree structure,
TreeList
Subscribe to:
Posts (Atom)