Create a hierarchical data grid

[Baiju K U]

Hi

I need to create Heirarchical data grid from a database view.

I have a data view which contains information like

Site Building Floor
--------------------------------------------------------------------------------

AGH Academic Center First Floor
AGH Academic Center Second Floor
AGH Academic Center Third Floor
AGH Academic Center Fourth Floor
AGH Gelman Library First Floor
AGH Gelman Library Second Floor
AGH Gelman Library Third Floor
LGH Acheson Building First Floor
LGH Acheson Building Second Floor
LGH Acheson Building Third Floor




etc....

I need to present the information as

Site : AGH
Building : Academic
Floor
First
Second
Third
Fourth
Building : Gelman Library
Floor
First
Second
Third
Site :LGH
Building : Acheson Building
Floor
First
Second
Third

I need to provide check box on the left of every entity for making a selection. If I select a Building all the floors should be selected and vice versa. How can I implement this in a data grid


Thanks
Baiju

 

[Ken Cox [Microsoft MVP]]

"The HierarGrid takes a DataSet that contains relations between the tables.
While iterating over the parent table it checks the related tables for child
rows and if one is found it dynamically loads a template for the child
row(s).
The template is rendered invisibly into the custom HierarColumn and when the
user clicks the plus icon, the template content is copied via JavaScript
into a newly created TableRow."

http://www.denisbauer.com/ASPNETControls/HierarGrid.aspx


Hi

I need to create Heirarchical data grid from a database view.

I have a data view which contains information like

Site Building Floor
--------------------------------------------------------------------------------

AGH Academic Center First Floor
AGH Academic Center Second Floor
AGH Academic Center Third Floor
AGH Academic Center Fourth Floor
AGH Gelman Library First Floor
AGH Gelman Library Second Floor
AGH Gelman Library Third Floor
LGH Acheson Building First Floor
LGH Acheson Building Second Floor
LGH Acheson Building Third Floor




etc....

I need to present the information as

Site : AGH
Building : Academic
Floor
First
Second
Third
Fourth
Building : Gelman Library
Floor
First
Second
Third
Site :LGH
Building : Acheson Building
Floor
First
Second
Third

I need to provide check box on the left of every entity for making a
selection. If I select a Building all the floors should be selected and vice
versa. How can I implement this in a data grid


Thanks
Baiju