TreeView Control help pretty please.

[Law]

Hi All

Was contemplating about inserting ca 4000 nodes with a hierarchy of ca
6 levels inside a treeview control (I'm intending to use Microsoft
TreeView control version 6).

The below is an example of my data set which lies within an excel
sheet starting at range A1 (data set contains headers):

NodeID ¦ NodeDescription ¦ ParentID
N0000 Papa Smurf
N0001 Smurfette N0000
N0002 Hefty Smurf N0000
N0003 Baby Smurf N0002
....


The NodeDescription is to be used as the name displayed for the node.

I figure to do this efficiently I need some kind of special sort
function.

Any suggestions or fully working code would be greatly appreciated.


Hope to hear from someone soon.

Thanks for reading.

Lars.

 

[Ed Ferrero]

Hi Lars,

Ken Puls has a tutorial here
http://proofficedev.com/blog/2007/03/13/using-a-treeview-control-in-microsoft-excel

Ed Ferrero
www.edferrero.com


Hi All

Was contemplating about inserting ca 4000 nodes with a hierarchy of ca
6 levels inside a treeview control (I'm intending to use Microsoft
TreeView control version 6).

The below is an example of my data set which lies within an excel
sheet starting at range A1 (data set contains headers):

NodeID ¦ NodeDescription ¦ ParentID
N0000 Papa Smurf
N0001 Smurfette N0000
N0002 Hefty Smurf N0000
N0003 Baby Smurf N0002
....


The NodeDescription is to be used as the name displayed for the node.

I figure to do this efficiently I need some kind of special sort
function.

Any suggestions or fully working code would be greatly appreciated.


Hope to hear from someone soon.

Thanks for reading.

Lars.

 

[Law]

Hi Ed

I checked out that link but can see straight away that I will need
some sort of quicksort function to process the 4000 nodes with ca a
hierarchy of 6 levels. Currently with the examples provided I
understand that I would have to loop through every node to find a
child node and continue recursively. However was hoping that someone
could post me somecode of a treeview control that works efficiently or
semi-efficiently with a large data set or alternatively give me hints
of how to go about it?

Thanks

L

 

[Law]

Hi Ed

I checked out that link but can see straight away that I will need
some sort of quicksort function to process the 4000 nodes with ca a
hierarchy of 6 levels. Currently with the examples provided I
understand that I would have to loop through every node to find a
child node and continue recursively. However was hoping that someone
could post me somecode of a treeview control that works efficiently or
semi-efficiently with a large data set or alternatively give me hints
of how to go about it?

Thanks

L