Algoritem to get data for TreeVieew

[shmul]

i need to get data from DB to fill a treeView with no limit to the treeview depth, i don't want to use recursive function because of overhead, if any one can give me an example of cod...

[BruceG]

Believe it or not, for this kind of thing my old COBOL experience comes in to play (I knew it would be good for something :)). First, make sure your recordset is sorted by the appropriate keys (for example, let's say Region, State, City). Then, using the old COBOL concept of processing a file with "control breaks", you could set up a nested loop like the following:


Dim strPrevReg As String
Dim strPrevState As String
Dim strPrevCity As String
' ...
' ... add root node of tree
rs.MoveFirst
Do Until rs.EOF
strPrevReg = rs!Region
' Add "grandfather" node for Region(one level below root)
Do Until rs.EOF
If strPrevReg <> rs!Region Then Exit Do
strPrevState = rs!State
'Add "father" node for State (2 levels below root)
Do Until rs.EOF
If strPrevState <> rs!State Then Exit Do
strPrevCity = rs!City
intCityCount = 0
Do Until rs.EOF
If strPrevCity <> rs!City Then Exit Do
' do processing, for example, count how
' many records for a particular city
intCityCount = intCityCount + 1
rs.MoveNext
Loop
' Add a "child" node for City (3 levels below root) possibly containing city name and count
' If there was only record per city, adding this node would go inside the previous loop
Loop
Loop

[tonyenkiducx]

Im not quite sure if thats what he ment... I think he ment that he can go down an unlimited number of nests(is nests the right word?), without needing to code for reach progressive son.. in which case the only sensible way is with recursive functions, but Id advise against that, just live with set sizes.