How to Populate TreeView from multiple tables

[jo_eylee]

How can I populate a Treeview from Ms Access database which contains tables of :- 1. Parent (parent_id, parent_name) 2. Child (child_id, child_name) 3. ParentChildRelation (id, parent_id, child_id) The reason that I cannot use single parent-child table is I have child with multiple parents and parent with multiple child (M-to-M). How do I solve this in populating a treeview? Any sample demo with source code? :confused:

[Leah_Garrett]

I have done something similar to this. I made one table that contained the data I wanted all in one table, all in order. The data had a three level hierarcy (Parent - 1, child - 2, grandchild -3). So when I looped through the table I would check the level and create a node accordingly. Private Sub PopulateNavigationTree() TopicTreeView.BeginUpdate() TopicTreeView.Nodes.Clear() Dim parentNode As TreeNode Dim childNode As TreeNode 'Dim fullPath As String Dim iLevel As Integer = 0 Dim baseNode As TreeNode = TopicTreeView.Nodes.Add("Topics") ' init to valid values for safety parentNode = baseNode childNode = baseNode Dim myRow As DataRow If m_TreeDataSet.Tables.Count > 0 Then If m_TreeDataSet.Tables(0).Rows.Count > 0 Then For Each myRow In m_TreeDataSet.Tables(0).Rows iLevel = CType(myRow.Item("Level").ToString, Integer) If iLevel = 1 Then parentNode = baseNode.Nodes.Add(myRow.Item("Topic").ToString) ElseIf iLevel = 2 Then childNode = parentNode.Nodes.Add(myRow.Item("Topic").ToString) Else childNode.Nodes.Add(myRow.Item("Topic").ToString) End If Next End If Else ' TO DO: add error message here End If TopicTreeView.CollapseAll() baseNode.Expand() TopicTreeView.EndUpdate() End Sub