I have a table named tbl_Folder and the columns are
idx_folder
folder_name
idx_parent
idx_client
idx_policy_year
If the parent folder has parent id 0 and id is 1.And subfolder will have parent id as 1. How i will get the hierarchy as below.
Folder Parent>SubFolder1>subfolder12......
using asp.net,javascript