How to copy sum of Child Column values to Parent Column

Hi Petar,

Thanks for your reply... here how i am using my dataset for hierarchical display

.Aspx

<ig:WebHierarchicalDataGrid ID="WebHierarchicalDataGrid1" runat="server" Height="712px"

Width="827px" DataKeyFields="ID" DataMember="Parent" AutoGenerateBands="False" OnInitializeRow="WebHierarchicalDataGrid1_OnInitializeRow"

AutoGenerateColumns="False" Key="Parent">

<ig:BoundDataField DataFieldName="FrameWorkName" Key="FrameWorkName" >

</ig:BoundDataField>

<ig:TemplateDataField Key="OpenFindings">

<asp:Label ID="Label_ParentOpenFindings" runat="server" Text='<%# Eval("OpenFindings") %>' Width="250px"></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="ClosedFindings">

<asp:Label ID="Label_ParentClosedFindings" runat="server" Text='<%# Eval("ClosedFindings") %>' Width="250px"></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="Rating">

<asp:Label ID="Label_ParentRating" runat="server" Text="" Width="250px"></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="AddControl">

<asp:Button runat="server" ID="Button_ParentAddControl" CssClass="submitSmallButton" Text="Add"

ToolTip="Add Control" CausesValidation="false"></asp:Button>

</ItemTemplate>

</ig:TemplateDataField>

</Columns>

<Bands>

<ig:Band AutoGenerateColumns="False" DataMember="Child1" Key="Bands" DataKeyFields="ID">

<ig:BoundDataField DataFieldName="FrameWorkName" Key="FrameWorkName">

</ig:BoundDataField>

<ig:TemplateDataField Key="OpenFindings">

<asp:Label ID="Label_Child1OpenFindings" runat="server" Text='<%# Eval("OpenFindings") %>'></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="ClosedFindings">

<asp:Label ID="Label_Child1ClosedFindings" runat="server" Text='<%# Eval("ClosedFindings") %>'></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="Rating">

<asp:Label ID="Label_Child1Rating" runat="server" Text=""></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="AddControl">

<asp:Button runat="server" ID="Button_Child1AddControl" CssClass="submitSmallButton" Text="Add"

ToolTip="Add Control" CausesValidation="false"></asp:Button>

</ItemTemplate>

</ig:TemplateDataField>

</Columns>

<Bands>

<ig:Band AutoGenerateColumns="False" DataMember="Child2" Key="Child2" DataKeyFields="ID">

<ig:BoundDataField DataFieldName="FrameWorkName" Key="FrameWorkName">

</ig:BoundDataField>

<ig:TemplateDataField Key="OpenFindings">

<asp:Label ID="Label_Child2OpenFindings" runat="server" Text='<%# Eval("OpenFindings") %>'></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="ClosedFindings">

<asp:Label ID="Label_Child2ClosedFindings" runat="server" Text='<%# Eval("ClosedFindings") %>'></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="Rating">

<asp:Label ID="Label_Child2Rating" runat="server" Text=""></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="AddControl">

<asp:Button runat="server" ID="Button_Child2AddControl" CssClass="submitSmallButton" Text="Add"

ToolTip="Add Control" CausesValidation="false"></asp:Button>

</ItemTemplate>

</ig:TemplateDataField>

</Columns>

<Bands>

<ig:Band AutoGenerateColumns="False" DataMember="Child3" Key="Child3" DataKeyFields="ID">

<ig:TemplateDataField Key="Control">

<asp:Label ID="Label_Control" runat="server" Text='<%# Eval("Control") %>'></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="OpenFindings">

<asp:Label ID="Label_Child3OpenFindings" runat="server" Text='<%# Eval("OpenFindings") %>'></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="ClosedFindings">

<asp:Label ID="Label_Child3ClosedFindings" runat="server" Text='<%# Eval("ClosedFindings") %>'></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="Result">

<asp:Label ID="Label_Result" runat="server" Text=""></asp:Label>

</ItemTemplate>

</ig:TemplateDataField>

<ig:TemplateDataField Key="Delete">

<asp:LinkButton CommandArgument='<%# Bind("Id") %>' ID="LinkButton_Delete" OnClick="LinkButton_Delete_Click"

runat="server"><img src="../../static/images/trash_16x16.gif" width="12" height="11" alt="Delete Control" title="Delete Control" /></asp:LinkButton>

</ItemTemplate>

</ig:TemplateDataField>

</Columns>

</ig:Band>

</Bands>

</ig:Band>

</Bands>

</ig:Band>

</Bands>

<ig:EditingCore EnableInheritance="true">

</ig:EditingCore>

</Behaviors>

</ig:WebHierarchicalDataGrid>

.Apspx.cs

//Create relations

DataColumn parentColumn = dataset.Tables[0].Columns["ID"];

DataColumn childColumn = dataset.Tables[1].Columns["ParentID"];

DataRelation genreBandsRelation = new DataRelation("RelationName", parentColumn, childColumn, false);

DataColumn parentColumn1 = dataset.Tables[1].Columns["ID"];

DataColumn childColumn1 = dataset.Tables[2].Columns["ParentID"];

DataRelation bandsSongsRelation = new DataRelation("RelationName1", parentColumn1, childColumn1, false);

DataColumn parentColumn2 = dataset.Tables[2].Columns["ID"];

DataColumn childColumn2 = dataset.Tables[3].Columns["ID"];

DataRelation bandsSongsRelation1 = new DataRelation("RelationName2", parentColumn2, childColumn2, false);

dataset.Relations.Add(genreBandsRelation);

dataset.Relations.Add(bandsSongsRelation);

dataset.Relations.Add(bandsSongsRelation1);

WebHierarchicalDataGrid1.Rows.Clear();

WebHierarchicalDataGrid1.DataSource = dataset;

and as well as my data is displaying like this

Parent:--------------0

Child1:----------0

Child2:-----------0

Child3-------2

Child4-------3

and i need like this

Parent:----------------9

Child1:-----------4

Child2:-----------5

Child3-------2

Child4-------3