Posted on 2001-08-20
Basically I want to use a treeview, but have never used one. Yes I know you are asking what I have been doing all this time, but most of the the time I write server side code and not UI. Anyways back to the point in hand......
I want to populate a tree view from the following table:
ID - primary key autonumber
Desc - eg. Liverpool V Man Utd (this is the field in the tree)
Parent ID - This will link back to the ID in a one to many / parent child type format. Eg the example for desc will always be the parent, but a child could be robbie fowler to score the first goal etc etc. Basically if you havent guessed, it is for a betting system.
So......if I have my table populated with all these parents and childs, then what properties do I have to use to get the tree looking somthing like:
Liverpool V Man Utd
Chelsea to win the league
Red Rum to win
Also this is only a prototype, so the table design can be changed if you feel it necessary to answer my question. If you have done something similar, but used a different table design then Im open to offers, as I just want the system up and running asap, and everything I am doing is flexible.