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
close icon

Can Essential Calculate be used to compute values across a dataset?


I've read that Essential Calculate can perform calculations on data that is in a DataTable, but I'd really like to be able to perform calculations across a hierarchical structure of objects. This could a DataSet, or a graph of ADO.NET entity objects, or some custom objects that I roll on my own.

The idea is something like this. I have a graph of objects, similar to those below:

Account
(
AccountID,
Name,
OrderTotals
)

PurchaseOrder
(
OrderID,
AccountID,
OrderTotal
)

PurchaseOrderItem
(
OrderID,
ItemID,
ItemPrice
)

An account has multiple orders and orders have multiple items. What I want to do is use CalcEngine (or some other Essential Calculate object, CalcQuick?) to perform calculations across this hierarchical dataset.

Can this sort of thing be done? One idea I had was to create a CalcWorkbook and add sheets that represent the various levels of the object graph and then use calculations between the sheets. Just an idea.

Any other thoughts?


2 Replies

JJ Jisha Joy Syncfusion Team December 3, 2008 09:40 AM UTC

Hi Sean,

Please refer the following browser samples shipped with our products and let me know if this helps.


..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\DataGridCalculator

..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\GridDataBoundGridCalculator

..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\TabbedPanelGrids

..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\WorkingWithCalcQuick

..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\XlsFileUsingExcelRW

Regards,
Jisha






AD Administrator Syncfusion Team December 3, 2008 12:06 PM UTC

Jisha,

Thanks for the links. I'll take a look at the samples and see if I can bend them to do what I need.

Regards,

Sean


Loader.
Live Chat Icon For mobile
Up arrow icon