I have an SQL table in the following format:
id categoryname parent id
1 cat1 0
2 cat2 1
3 cat3 2
4 cat4 0
5 cat5 4
how can i return a string like "cat1 > cat2 > cat3" when querying "3" or "cat4 > cat5" when querying "4" in asp.net? It isn't always going to be three categoryies deep.. i've never done a recursive query before.. can this be done using linq?
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)