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

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

Thread ID:

Created:

Updated:

Platform:

Replies:

78183 Dec 3,2008 12:03 AM UTC Dec 3,2008 12:06 PM UTC WinForms 2
loading
Tags: Calculate
Administrator [Syncfusion]
Asked On December 3, 2008 12:03 AM UTC


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?


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





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


CONFIRMATION

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.

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

;