Reply to thread

Message

<blockquote data-quote="DieBagger" data-source="post: 540416" data-attributes="member: 56421">Maybe I'm overlooking something here but to me this sounds like what you're searching for is recursion...Let me try if I can write some pseudo code:[CODE]public void Main(){//entry point&nbsp; &nbsp; TreeNode rootNode = new TreeNode(&quot;I am root&quot;);&nbsp; &nbsp; GetSubNodes(0, rootNode);}public void GetSubNodes(int _id, TreeNode _node){&nbsp;&nbsp; List&lt;Category&gt; subCategories = GET_SUB_FROM_SQL(_id);//get the sub-categories from sql&nbsp;&nbsp; foreach(Category c in subCategories)&nbsp;&nbsp; {&nbsp; &nbsp; &nbsp;&nbsp; TreeNode node = new TreeNode(c.category_name);&nbsp; &nbsp; &nbsp;&nbsp; node.Tag = c;&nbsp; &nbsp; &nbsp;&nbsp; GetSubNodes(c.category_id, node);//this is the recursion&nbsp; &nbsp; &nbsp;&nbsp; _node.SubNodes.Add(c);&nbsp; &nbsp; }}[/CODE]Fyi it's already late and I'm sure there's something wrong with the code but it should give you the idea <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" /></blockquote>

[QUOTE="DieBagger, post: 540416, member: 56421"] Maybe I'm overlooking something here but to me this sounds like what you're searching for is recursion... Let me try if I can write some pseudo code: [CODE] public void Main() {//entry point TreeNode rootNode = new TreeNode("I am root"); GetSubNodes(0, rootNode); } public void GetSubNodes(int _id, TreeNode _node) { List<Category> subCategories = GET_SUB_FROM_SQL(_id);//get the sub-categories from sql foreach(Category c in subCategories) { TreeNode node = new TreeNode(c.category_name); node.Tag = c; GetSubNodes(c.category_id, node);//this is the recursion _node.SubNodes.Add(c); } } [/CODE] Fyi it's already late and I'm sure there's something wrong with the code but it should give you the idea ;) [/QUOTE]

Verification