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
