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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

GridGroupingControl - Expression, Child Tables, References

Thread ID:





37234 Nov 17,2005 06:21 PM UTC Nov 18,2005 10:35 AM UTC WinForms 3
Tags: GridControl
Asked On November 17, 2005 06:21 PM UTC

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

Administrator [Syncfusion]
Replied On 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

Replied On 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

Administrator [Syncfusion]
Replied On 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


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon