The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
I am using a Grid Grouping Control Grid and a Grid Data Bound Grid.
The GGCG contains a hierarchy of two data tables. The child table references a third data table. The GDCG is read only, only used to sum up some data.
In the GDBG, some values should be changed by user. The data in the GDCG should be actualized after changing the values in GDBG without any further user action.
Usage of DataSet Relations –like dataTable.Columns.Add("colName", Type, "Sum(Child.ColumneToSum)") - doesn''t work properly, because data won''t be actualized immediately. To remove and new establish relations after changing data in GDBG on DataSet level leads to further difficulties.
Example in http://www.syncfusion.com/Support/user/uploads/GGC_MasterDetails_20e9a82d.zip doesn’t work properly: Edit child value in child table leads only to actualization on child sum in hierarchy grid, if one child is expanded in hierarchy grid.
Does anybody have some examples on Expressions (ExpressionFieldDescriptor) to use with nested tables?
Is there any example with nested tables over three levels resulting in dynamically actualized sumd independent of status of nested tables?
Thanks in advance
Markus
ADAdministrator Syncfusion Team November 17, 2005 06:51 PM UTC
By default, the GridDataBoundGrid only raises the IBindingList.ListChanged event when you leave the current row. It is this event that other datasource users listen to so they know they need to update themselves with an outside change. If you want the changes to happen as soon as you leave teh cell (but not necessarily the row), then try setting grid.Binder.DirectSaveCellInfo = true.
These seems to work for me in the sample below. The inner most table in the GridGroupingControl has an expression column. It will update when you change the GridChildID column in the inner most table of the GridDataBoundGrid (must change to an high integer as this is the primary key column to avoid a constraint exception). So, in this sample, changes in the GridDataBoundGrid (with DirectSaveCellInfo = true) trigger the expression calculation in the GridGroupingControl.
http://www.syncfusion.com/Support/user/uploads/GDBG_GGC_64036886.zip
MAmarkusNovember 18, 2005 09:27 AM UTC
Thanks.
Is there any chance to show
sum of "ID-10"
on child table level based on expression?
How to have access in expressions on parent or child level?
Best regards
Markus
ADAdministrator Syncfusion Team November 18, 2005 10:35 AM UTC
No easily. To have summations in hierarchical data, it is less coding to use our GridGroupingControl.
You can add an unbound column to the parent and use QuerycellInfo to try to sum the child and provide the sum when the parent cell is requested. This forum thread has a little sample in it.
http://www.syncfusion.com/Support/forums/message.aspx?MessageID=36908