How to retrieve tree view based on id from database table

Question

am binding tree view from database i have 4 parents with their childs in my tree view am binding all parents with childs. But i want to bind only a particular parent with their childs  how to write query for that My table EmpID Name ReportsTo 1 Accounts 0 2 Branches 0 3 Loans 1 4 Incomes 2 Accounts branches are parents loans incomes their childs what is the query to return Accounts with childs @helper GetTreeView(List siteMenu int parentID) { foreach (var i in siteMenu.Where(a => a.ReportsTo.Equals(parentID))) { @{var submenu = siteMenu.Where(a => a.ReportsTo.Equals(i.EmpID)).Count();} @if (submenu > 0) {   } else {   } @i.Name @* @i.Name *@ @if (submenu > 0) { @Treeview.GetTreeView(siteMenu i.EmpID) @* Recursive Call for Populate Sub items here*@ } } }

Vinay Singh · Answer

Hi Please check the link http://www.c-sharpcorner.com/UploadFile/3d39b4/bootstrap-tree-view-in-Asp-Net-mvc/ http://www.dotnetawesome.com/2014/06/how-to-create-treeview-with-database-data-mvc4-aspnet.html

madhu goud · Answer

am not getting sir can you give me sample query

Nitin Sontakke · Answer

Consider using CTE (Common Table Expression) to get the hierarchical data from db. Try to avoid recursive calls to db. In the first query of the CTE you can have a where clause to filter the records for just one passed value.