We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

GridGroupingControl - Expression, Child Tables, References

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

3 Replies

AD Administrator 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


MA markus November 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


AD Administrator 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

Loader.
Live Chat Icon For mobile
Up arrow icon