Parent Child Hierachy in asp.net

Question

enter image description here

I want to show family hierachy in asp.net.

I have table as Family with attributes ParentID, ChildID, Name. Table have seft join on ParentID and ChildID. How I show the data from database. The hierarchy level is not fix.

#edited

I want aspx part to show this hierarchy tree i.e How I will show this tree in aspx using reapeater or other any control.

score 0 · Answer 1 · answered Apr 09 '13 at 07:13

Just create table in Database 'Person','ParentChild'. 'Person' table with columns Id and Name, 'ParentChild' with columns ParentId and ChildId. ParentId and ChildId will have reference to Id column in 'Person' table, so you can save easy your hierarchy, and get with query.

score 0 · Answer 2 · answered Apr 09 '13 at 07:20

0

The structure you have shown here is like a tree. So the simplest approach will be to implement SQL tree at the backend. Once you have done that there is a tree view control in asp.net that you can use to show up the data on front end. The best i could find is Here

answered Apr 09 '13 at 07:20

Syed Mohd Mohsin Akhtar

451
5
20

I want to show tree as shown in the diagram not as a collapse expand tree view. – user Apr 09 '13 at 07:33
for this you should I will recommend using jquery plugin [jOrgChart](http://dl.dropbox.com/u/4151695/html/jOrgChart/example/example.html) just populate a list using asp.net and use jQuery plugin to display – Syed Mohd Mohsin Akhtar Apr 09 '13 at 07:44
if the solution provided answers your query pls vote and accept else comment – Syed Mohd Mohsin Akhtar Apr 09 '13 at 10:00
I have a structure of that tree but I am not able to bind the data to tree from c# to Aspx – user Apr 10 '13 at 07:02
have you gone through the tutorial well – Syed Mohd Mohsin Akhtar Apr 10 '13 at 08:34

Parent Child Hierachy in asp.net

2 Answers2