Solved

Populate Treeview child nodes from a database

Posted on 2009-07-15
10
401 Views
Last Modified: 2012-05-07
I build a treeviews parent and 1st child nodes from a sitemap. so it looks like this:

- Cars
    - Ford
    - Nissan
 
Now I hit the database and generate a datatable, dt("Ford Models"). How do I bind the datatable to the "ford" child node so it looks like this?
- Cars
     - Ford
           - Taurus
           - Mustang
           - Fusion
Thanks!
0
Comment
Question by:bertino12
  • 5
  • 5
10 Comments
 

Author Comment

by:bertino12
ID: 24860101
Right now, I am just trying it like this, but when the page is finished loading it doesnt display the node as populated.
    Private Sub Page1_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles Page1.Unload
        Dim dt As DataTable = popRootNodes()
        Dim parentNode As TreeNode = Nothing
        Dim currNode As TreeNode = Nothing
        Dim newNode As TreeNode = Nothing
 
        parentNode = Me.TreeView1.Nodes.Item(0)
        currNode = parentNode.ChildNodes.Item(0)
 
        newNode = New TreeNode("Taurus", "Taurus")
        currNode.ChildNodes.Add(newNode)
 
        newNode = New TreeNode("Mustang", "Mustang")
        currNode.ChildNodes.Add(newNode)
 
        newNode = New TreeNode("Fusion", "Fusion")
        currNode.ChildNodes.Add(newNode)
 
        currNode.Expanded = True
    End Sub

Open in new window

0
 
LVL 7

Accepted Solution

by:
Randy Wilson earned 500 total points
ID: 24861252
Is this ASP.Net?  Web TreeView has no Item collection...
0
 

Author Comment

by:bertino12
ID: 24861633
Yes asp .net, so how do you add items dynamically?
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 7

Expert Comment

by:Randy Wilson
ID: 24861935
parentNode = Me.TreeView1.Nodes.Add(someTreeNodehere)
0
 
LVL 7

Expert Comment

by:Randy Wilson
ID: 24861956
If you are looking for a more complete answer, post more complete code.  BTW, why are you doing this in the Page Unload Event?
0
 

Author Closing Comment

by:bertino12
ID: 31603874
Ok for the web treeview use PopulateOnDemand
0
 
LVL 7

Expert Comment

by:Randy Wilson
ID: 24862182
There is no PopulateOnDemand property/method for the Web TreeView.  Would not make sense in the PostBack (stateless) environment of the web.
0
 

Author Comment

by:bertino12
ID: 24862218
0
 

Author Comment

by:bertino12
ID: 24862253
0
 
LVL 7

Expert Comment

by:Randy Wilson
ID: 24862274
My bad, did not pay attention to the question..
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lots of people ask this question on how to extend the “MembershipProvider” to make use of custom authentication like using existing database or make use of some other way of authentication. Many blogs show you how to extend the membership provider c…
I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question