Related Posts
  • Forum Post: Re: Re: View accounts like hierarchy / treeview

    Hi Yaniv, Thank you for your reply. That is exactly what I am trying to achieve. I am able to get the selected account GUID, but I am not sure of an efficient way to find/select only the related accounts. Some, but not all, "branches" may have 5 or 6 levels. So what I need is to find all...
  • Forum Post: Re: Re: View accounts like hierarchy / treeview

    Thanks anyway Hassan, but I need to build a solution not buy one. Post the source code if you really want to help.
  • Forum Post: Re: Re: Re: Re: View accounts like hierarchy / treeview

    Yaniv, Thank you again for responding. I completely agree with you that a direct query to the FilteredAccount view is the way to go. The problem still exists though that the query will not receive the top account GUID, but the selected account GUID. The user may or may not have selected the top account...
  • Forum Post: Re: View accounts like hierarchy / treeview

    Here is what I have. Maybe it will help to get an answer to what I need. Create a new C# web application project in your favorite VS version. Rename the ASPX page to AccountHierarchy. Drag an XML control onto it. Paste this code into the AccountHierarchy.aspx.cs window under Page_Load (Replacing...
  • Forum Post: Re: Re: Re: Re: Re: Re: Re: Re: View accounts like hierarchy / treeview

    You rock! Thank you very much Andrew this is excellent work. It is almost there. I'm just missing the parent nodes (really the root account of the branch to use as the anchor in the query). I thought it was a done deal when one of our DBA's said that he wrote a function to get the "root"...
  • Forum Post: View accounts like hierarchy / treeview

    I need to create a solution to display accounts like a hierarchy or in a tree view. I was able to create a solution to display all of the accounts in the system this way by modifying something I found here ( http://www.c-sharpcorner.com/UploadFile/desaijm/database_hierarchy_with_datarelation02192006170040PM...