开发者

Draw a tree or organization chart from parent child data

I have parent-child information in a table with GroupID (TreeID.)

Draw a tree or organization chart from parent child data

From this table I want to derive something like this:

Draw a tree or organization chart from parent child data

The purpose of drawing a tree is for viewing only. The table has thousands of groupID/tree structures.

I am using the .NET platform.

How should I proceed?

create table parent_child (GroupID varchar(100) null, 开发者_JAVA百科  
                           Level varchar(100) null, 
                           Name varchar(100) null,  
                           ID varchar(100) null,    
                           ParentID varchar(100) null,  
                           Top_Parent varchar(100) null)

 insert into parent_child (GroupID,Level, Name,ID,ParentID,Top_Parent) values 
     ('1234', '4', 'James', '6712', '921', '1005'), 
     ('1234', '3', 'Peter', '11', '206', '1005'),
     ('1234', '3', 'Royden', '14', '206', '1005'), 
     ('1234', '3', 'Lila', '237', '589', '1005'),
     ('1234', '3', 'Julie', '921', '589', '1005'), 
     ('1234', '2', 'Sandy', '206', '1005', '1005'), 
     ('1234', '2', 'Tom', '589', '1005', '1005'), 
     ('1234', '1', 'Sam', '1005', 'NA', '1005')


The article A Graph Tree Drawing Control for WPF (at The Code Project) explains how to achieve what you have in mind, both in WPF and Silverlight. Kudo's to the guy who made the code available - it's well written and very easy to customize.

Screenshot from The Code Project site:

Draw a tree or organization chart from parent child data

You will have to write the logic to convert your table data to a compatible data structure.

I hope the article helps!

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜