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 50693
This 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