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.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

78183 Dec 2,2008 07:03 PM Dec 3,2008 07:06 AM Windows Forms 2
loading
Tags: Calculate
Administrator [Syncfusion]
Asked On December 2, 2008 07:03 PM


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 04:40 AM

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 07:06 AM

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.

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.

;