[RESOLVED] Loading GrandChildNodes from DB

[aikidokid]

Right, with this code, added after the Childnodes are added, I am now getting what is shown in the image, but I am now stumped.

There should only be 2 entries, not a third empty one, and they are supposed to be the next level in!

'if no Child node, is there a grandchild node
        If strNodeChild = "" Then
            If strNodeGrandChild <> rs.Fields("tvwGrandChildNodes").Value & "" Then
                'if Fields is not empty - add new grandchild node
                strNodeGrandChild = rs.Fields("tvwGrandChildNodes").Value & ""
                .Nodes.Add "P" & CStr(lngNodeParent), tvwLast, , strNodeGrandChild, "Leaf"
            End If
        Else
            If strNodeGrandChild <> rs.Fields("tvwGrandChildNodes").Value & "" Then
                'if Fields is not empty - add new grandchild node
                strNodeGrandChild = rs.Fields("tvwGrandChildNodes").Value & ""
                .Nodes.Add "C" & CStr(lngNodeChild), tvwLast, , strNodeGrandChild, "Leaf"
            End If
        End If