Algorithm to get data from access database to tree view in C #
I have an access database from which i have to retrieve data from access database into c# showing tree view in my application. here is what i want to do. I have this access database with the following tables.
categoryid | Category Name | Parent Category
===============================================
1000 Food 996
996 contemporary 13
995 Anything 13
13 Glassware 50693This is just an example so now when the tree is displayed it should be like this
Glassware (13)
||
-> Contemporary (996)
||
-> Food (1000)
-> Anything (995)
Like this there are numerous parent and child categories. I am trying to find an algorithm in c Sharp which will do this for me.
I appreciate any help which i can get
|