Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
jason
1329
Binding a DataSet from the code behind.
posted

I am using VS2010 with 2011.1 controls with VB.NET. I have 3 unnamed datatables that are returned as a single dataset in the code behind. I need to bind this dataset to a WebHierarchicalDataGrid. I do not wish to display any headers and would like to add an unbound checkbox as the first column in each row. When I check "Metal", the grid will expand to show "Ratt" and "Whitesnake". If I expand "Whitesnake", the grid will expand to show "Slide it in". Pretty simple in concept but I cannot for the life of me get it to work even after looking at several code examples. Thanks for the help!

ID PARENTID NAME
1 null Metal
2 null Rock

 

ID PARENTID NAME
1 1 Ratt
2 1 Whitesnake
3 2 Van Halen

 

ID PARENTID NAME
1 1 Out of the Cellar
2 1 Invasion of your Privacy
3 2 Slide it in
4 3 Fair Warning

 

Parents
  • 8160
    posted

    Hello jdymond,
    I would suggest you to use one Self-Reference table instead of these three. For example:

    ID PARENTID NAME
    1 null Metal
    2 null Rock
    2 1 Ratt
    3 1 Whitesnake
    4 2 Van Halen
    5 3 Out of the Cellar
    6 3 Invasion of your Privacy
    7 4 Slide it in
    8 5 Fair Warning

    Please find the attached Sample and let me know if you need additional assistance

Reply Children