I need to populate tree view from the database table.
Example Hierarchy is like this..
We have all the brokers at the top level. Under the brokers we have clients. Under the cients we have trasaction types which he deals on(cash,margin,spot etc..).
BrokerCode Client code TransType
======= ======= =======
001 Client1 Cash
001 Client1 Margin
001 Client2 Margin
002 Test Spot
003 Test1 Cash
003 Test2 Cash
Output should be something like this....
Assume that i have all the rows in a datawindow or datastore. Please give me the code from there on.
Thanks in advance