Nested Tree Model to Windows form TreeView. It's not even a question. I need some help to make decision.

See more:

VB

SQL

TreeListView

I have homework to do, and i stuck :(

Some data:

create table forest ( tre int, lft int, rgt int, itm varchar(255));
insert into forest (tre, lft, rgt, itm) values (1, 1, 10, 'computer A');
insert into forest (tre, lft, rgt, itm) values (1, 2, 7, 'mainboard');
insert into forest (tre, lft, rgt, itm) values (1, 3, 4, 'processor');
insert into forest (tre, lft, rgt, itm) values (1, 5, 6, 'vga');
insert into forest (tre, lft, rgt, itm) values (1, 8, 9, 'hdd');
insert into forest (tre, lft, rgt, itm) values (2, 1, 14, 'computer B');
insert into forest (tre, lft, rgt, itm) values (2, 2, 13, 'mainboard');
insert into forest (tre, lft, rgt, itm) values (2, 3, 4, 'processor');
insert into forest (tre, lft, rgt, itm) values (2, 5, 6, 'vga');
insert into forest (tre, lft, rgt, itm) values (2, 7, 12, 'raid');
insert into forest (tre, lft, rgt, itm) values (2, 8, 9, 'hdd a');
insert into forest (tre, lft, rgt, itm) values (2, 10, 11, 'hdd b');

tre - id of tree
lft, rgt - mark of place in tree
itm - some data

User click [Rise trees] button.

Data are getting to [Forest], strong typed DataTable, with same structure as 'forest' in SQL.

private sub RiseTrees()
   dim drw as ForestRow
   For Each drw In Forest.Rows
      ' what the hell should i do here ???
   Next
end sub

I found examples, showing import adjacency model to treeview, but i have to first convert NestedTree to AdjacencyTree.

Is there any better way?


PS. I use Visual Studio 2005 Standard with .NET 2.0