Hi Petar,

I tried to add columns with this code but I'm getting an empty WebHierarchicalDataGrid, what could be the problem please ? 

  

if (!Page.IsPostBack)

{

dsModele = new DataSet("Model"

);

dsModele.Tables.Add(

 

 

"Model"

);

dsModele.Tables[0].Columns.Add(

 

 

"ID"

);

dsModele.Tables[0].Columns.Add(

 

 

"Category"

);

dsModele.Tables[0].Columns.Add(

 

 

"Titre"

);

dsModele.Tables[0].Columns.Add(

 

 

"valeur"

);

dsModele.Tables[0].Rows.Add(1,

 

 

"Category1", "Titre11", "Valeur11"

);

dsModele.Tables[0].Rows.Add(2,

 

 

"Category1", "Titre12", "Valeur12"

);

dsModele.Tables[0].Rows.Add(3,

 

 

"Category2", "Titre21", "Valeur21"

);

dsModele.Tables[0].Rows.Add(4,

 

 

"Category3", "Titre31", "Valeur31"

);

dsModele.Tables[0].Rows.Add(5,

 

 

"Category3", "Titre32", "Valeur32"

);

　

 

 

 

// Create band

 

 

 

Band childBand = new Band

();

childBand.DataKeyFields =

 

 

"ID"

;

 

 

 

// Set the key from the data source

childBand.Key =

 

 

"Model"

;

childBand.DataMember =

 

 

"Model"

;

 

 

 

this

.WebHierarchicalDataGrid1.Bands.Add(childBand);

　

 

 

 

BoundDataField boundField = new BoundDataField(true

);

 

 

 

// Define column for the child band

boundField =

 

 

new BoundDataField(true

);

boundField.Key =

 

 

"ID"

;

boundField.Header.Text =

 

 

"ID"

;

boundField.DataFieldName =

 

 

"ID"

;

 

 

 

this.WebHierarchicalDataGrid1.Bands["Model"

].Columns.Add(boundField);

 

 

 

// Define column for the child band

boundField =

 

 

new BoundDataField(true

);

boundField.Key =

 

 

"Category"

;

boundField.Header.Text =

 

 

"Category"

;

boundField.DataFieldName =

 

 

"Category"

;

 

 

 

this.WebHierarchicalDataGrid1.Bands["Model"

].Columns.Add(boundField);

 

 

 

// Define column for the child band

boundField =

 

 

new BoundDataField(true

);

boundField.Key =

 

 

"Titre"

;

boundField.Header.Text =

 

 

"Titre"

;

boundField.DataFieldName =

 

 

"Titre"

;

 

 

 

this.WebHierarchicalDataGrid1.Bands["Model"

].Columns.Add(boundField);

 

 

 

// Define column for the child band

boundField =

 

 

new BoundDataField(true

);

boundField.Key =

 

 

"valeur"

;

boundField.Header.Text =

 

 

"valeur"

;

boundField.DataFieldName =

 

 

"valeur"

;

 

 

 

this.WebHierarchicalDataGrid1.Bands["Model"

].Columns.Add(boundField);

　

 

 

 

DataView dv = dsModele.Tables["Model"

].DefaultView;

dv.Sort =

 

 

"Category ASC"

;

 

 

 

//add a new table called "Categories" with the distinct Country column values from the Customers table

dsModele.Tables.Add(dv.ToTable(

 

 

"Categories", true, "Category"

));

 

 

 

//Set up a data relation for the Customers table with the Countries table

 

 

 

//using the country column values to match records in a parent-child relationship

 

 

 

DataRelation rel = new DataRelation("CategoryModel"

,

dsModele.Tables[

 

 

"Categories"].Columns["Category"

],

dsModele.Tables[

 

 

"Model"].Columns["Category"

]);

dsModele.Relations.Add(rel);

 

 

 

// Set the table's primary key field

dsModele.Tables[

 

 

"Categories"].PrimaryKey = new DataColumn

[] {

dsModele.Tables[

 

 

"Categories"].Columns["Category"

] };

 

 

 

// Store the data in Session state

 

 

 

this.Session["CategoryModel"

] = dsModele;

}

 

 

 

// Retrieve data from Session state

 

 

 

DataSet ds = this.Session["CategoryModel"] as DataSet

;

 

 

 

this

.WebHierarchicalDataGrid1.DataSource = ds;

 

 

 

this.WebHierarchicalDataGrid1.DataMember = "Categories"

;

 

 

 

this.WebHierarchicalDataGrid1.DataKeyFields = "Category"

;

 

 

 

this

.WebHierarchicalDataGrid1.DataBind();

Hi Petar, Im having a problem with a WebHierarchicalDataGrid. When I populate the control without setting the columns, it works fine, but when I stablish wich columns my grid and its childs grids are going to show, there is my problem. It shows the grid but when I click the CollapseButton, it doesn't do anything. I've already set the DataFieldKeys (in both cases the same) but still. Is there anything else I have to do when I set the columns?

Thanks for your time
Jesus

Hello Petar, thanks for your reply. Let me explain you how Im populating the WHDG:

First, I use IList<myEntity>
I retrieve data from my database and store it in my generic List. One of the properties of this entity is a another IList where Im storing the detail information for each record. For example:

IList<Parent>
IDParent,Name,Address,IList<Children>

IList<Children>
IDChild,IDParent,Name,Age

I set up the columns and bands by using the wizard of the WHDG (not in code behind as the example you provided me shows). The I program a method to fill the WHDG like this:

IList<Parent> varListHeader = methodToRetrieveAllDataFromDB()
nameWHDG.DataSource = varListHeader
nameWHDG.DataBind()

In the aspx I have this for the WebHierarchicalDataGrid:

  <ig:WebHierarchicalDataGrid ID="dgLista" runat="server"
        AutoGenerateColumns="False" DataKeyFields="IDParent" Height="350px"
        Width="836px">
        <Columns>
       .................

I set up the DataKeyFields with the IDParent and in the Band I have something like this

<Bands>
            <ig:Band AutoGenerateColumns="False" DataMember="varListHeader"
                Key="varListHeader" DataKeyFields="IDParent">
                <Columns>
                    <ig:BoundDataField DataFieldName="IDChild" Key="IDChild">
                        <Header Text="Id of the Child" />
                    </ig:BoundDataField> 
                   .................
Do I have to do anything in the postback event?

Thanks in advance.
Jesus