How to retrieve data from the DB for recursively binding a jquery treeview using asp.net mvc

Question

I have a table structure like this.

id | Name | ParentId

so for example:

id | Name     | ParentId 
------------------------- 
1  | Alice    | 0 
2  | Bob      | 0 
3  | Charlie  | 1 
4  | David    | 2

where 'Alice' and 'Bob' are Parent nodes( which has Id = 0) and Alice has a child node named 'Charlie' and 'Bob' has a child node named 'David'. My question is, I need to retrieve the parent separately and the children in a collection. The 'Children' collection can have multiple parents and its children. Can anyone send me a code snippet using which I can retrieve Data from the database and populate the tree.

Which treeview control are you using? The default that ships with ASP.NET or a jQuery treeview plugin? — Kris van der Mast
– Kris van der Mast, Commented Jul 7, 2010 at 10:42
I see you edited the question. Even for jquery my code should be valid (with slight modification). — Jaroslav Jandek
– Jaroslav Jandek, Commented Jul 7, 2010 at 19:21

Community · Accepted Answer · 2017-05-23 10:24:37Z

1

Similar to How to populate treeview except the classes used will be from the System.Web.UI.WebControls namespace (they are named the same).

Also BeginUpdate and EndUpdate methods don't exist for obvious reasons.

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Jul 7, 2010 at 9:47

Jaroslav Jandek

9,5831 gold badge31 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mattias Jakobsson Over a year ago

It is usually not a good idea to use server controls in a asp.net mvc application. And this task is (at least in my opinion) a lot easier without server controls.

Collectives™ on Stack Overflow

How to retrieve data from the DB for recursively binding a jquery treeview using asp.net mvc

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related