Treeview - getting the selected branch

[blackbox]

Hi

I have a tv control that has different branches for different tables in a relational db.
I wish to be able to select any node and then enter a new child value that will also populate the underlying table. The question is, how do I identify which branch is selected and which underlying table that is from.

For example, If I select 'Manufacturer' and then type a new entry (Ford) into a text box, I want that entry to go into tblManufactures which will be reflected when the TV is refreshed, If I then select Ford and add a new entry then I wish for the entry to go into tblCars,but also to trap the primary key from the Ford record to keep the data related.

Root
---Manufacturer
------Ford
---------Focus
---------F150
---------Mustang
---------Explorer
------Ferrari
----------F40
----------F355
---Customers
------Mr Blonde
------Mr Brown
---Staff
------Jim
------Jack
------Paul
------Peter

How can I do this?

Thanks
bb

[specci48]

Hello blackbox,

i took the treeview example from the help file and added a simple textbox to add a new node to the current selected node.

If you want to implement much more features to manipulate the treeview (e.g. deleting or moving nodes) you may have a look at my ToDoTree application I posted here some time ago.


specci48

[blackbox]

Thanks specci48

Your app is great and I'll learn a huge amount from it. I'm now using the SelectedImageIndex property to store the ID from each row of my database in the tv control. That way I can refer back to the specific record. The only snag is that it does not accept Alpha characters. I was hoping that each node on the TV could be assigned a 'key', for example the 3rd record in the Customer table could be 'Cust3' etc. The only way I can see around this is to add a specific number to each record number, so record 3 from the Customers table would be 100000003 and record 3 from the manufactures table would be 200000003. Do you have any other ideas?

Thanks
bb

[specci48]

Hi blackbox,

since the selectedImgageIndex was not originally designed to act as a reference to a specific tablerow, I don't have other ideas for you.
But I think your solution should work well leaving enough space for a lot of tv channels...


specci48

[x7Q391kt]

Thank you so much for posting this. This is very useful!