Adding nodes to a treeview control

[Raistlin21_45]

Hi, I've been banging my head on the keyboard for a few days now searching for a solution to my problem. Iv'e searched Google for a solution but I can't seem to find any. The node information is stored in a MySQL database using the nodes.fullpath command or like this: lvl1\lvl2\lvl3 Now, I've seen and tried to use the treeview.nodes.add(1).nodes.add(2).nodes.add(3) with a split command but because I don't know how many levels there are before hand this makes a giant select case that makes me cry each time I see it. I want the routine to check if the level exists then add it if it doesn't and/or move to the next level. (Geez it sounds so simple writen like that...) Here is the routine I'm using Dim SQL As String = "Select * from troubleshooting order by node_path asc" Dim StrNodePath As String Dim nNode As TreeNode Dim BolNew As Boolean = True Dim X As Integer Dim StrNode As String RSProbleme = ReturnForm.StrConn.Execute(SQL) Do Until RSProbleme.EOF = True StrNodePath = RSProbleme("node_path").Value aNodePath = Split(StrNodePath, "\") For X = 0 To UBound(aNodePath) BolNew = True For Each nNode In TrVProbleme.Nodes If nNode.Text = aNodePath(X) Then BolNew = False End If Next If BolNew = True Then nNode.Nodes.Add(aNodePath(X)) <-- This is the line that gives me trouble End If Next RSProbleme.MoveNext() Loop When adding it gives me the error, "Object reference not set to an instance of an object." and using the variable watch in VS it says that nNode = Nothing. Any help will be greatly appreciated. (My head hurts from all that banging...) Thanks For every action there is an equal and opposite malfunction

[digicd1]

I am guessing that you created a treeview called TrVProbleme in your application. If you have not added any nodes to the treeview - then nNode will be nothing. You might want to try changeing the statement nNode.Nodes.Add(aNodePath(X)) to TrVProbleme.Nodes.Add(aNodePath(X)) Hope this helps Digicd1

[Hacknight94]

hi! have u finish adding nodes to a treeview control? can u help me! can u give me ur code and the code in SQL! i need it badly! i hope u can help me! thanks a lot! coder

[Raistlin21_45]

Indeed you are correct; while I did not change the line as you suggested I've added a If... End If checking if this was a root node or not then added your line. (Can't believe it was so simple :mad:grr...) Thanks a bunch!:-D Raist For every action there is an equal and opposite malfunction -- modified at 12:12 Wednesday 10th May, 2006

[Raistlin21_45]

What kind of code are you interested in and what is the purpose?(what is it supposed to do?) Raist For every action there is an equal and opposite malfunction

[Hacknight94]

good morning! a code that will retrieve the data from database or using query! i will use the treeview for making a organizational chart! one main ParentNode(Division),childnode(Department) and subchildnode(Section) Thanks for ur kindheart! "Giving something does not reduce what you have but gain more!" coder

[Hacknight94]

Good morning!The code that i will use is all that name in the node that wiil display is came from the database, or using query! i will use it in making organizational chart! the content is i have a parentnode(Division), Chilnode(Department) and SubChildnode(Section). thanks! " Giving something to anyone is not reducing what u have instead you gain more!" coder