I have an Access database table of customers names and other details. Some of them have ParentID fields that reference other users in the table. What I want to do is create a TreeView control on a form that populates depending on which customer ID is selected (via a textbox or listbox or somesuch control). The idea being that the Root node will consist of 1 customer, and there will be up to (but not always) 5 levels of child nodes from this. I will try to show this with a brief diagram (apologies for ASCII artwork) User 1 | |-- User 4 | | | |----User 11 | |----User 14 | | | |----User 21 | | | |---- User 34 | | | |--- User 22 | | | |----User 23 |-- User 5 | |----User 17 | | | |--- user 26 | |----User 19 I want classes writing for: 1) The query of the database 2) The population of the Treeview 3) The returning of how many customers are children of the root. 4) The returning of which generation a specific user ID is in relation to the root (1 - 5) 5) A routine that returns a value of 1 for the root nodes first child, and .1 for each other generation of child after 1.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
ASP.Net 2.0. Will be running on IIS and must be scalable to SQL Database at a later date.