Good day.
I cannot create a hierarchical grid that uses only one datatable. It almost works but there is a problem: all the rows in the table are shown as a root element.
Is there any way to filter out all the rows that have a parent row?
Example: |ROOT |-CAT_1 |--SUB_1_1 |--SUB_1_2 |---SUB_1_2_1 |---SUB_1_2_2 |--SUB_1_3 |-CAT_2 |--SUB_2_1 |---SUB_2_1_1 Data: ID,PARENT_ID,CATEGORY 1,0,"ROOT" 2,1,"CAT_1" 3,1,"CAT_2" 4,2,"SUB_1_1" 5,2,"SUB_1_2" 6,2,"SUB_1_3" 7,5,"SUB_1_2_1" 8,5,"SUB_1_2_2" 9,3,"SUB_2_1" 10,9,"SUB_2_1_1" Any ideas on how to do that?
Thank you.
Great, I is it only me? I didn't understood anything :( Sorry.
Could please you explain (with example) how to bind to DataTable that references itself?