ASP/VB/C# .NET Dynamic Calculations & Referencing

Question

I'm developing an app in which there's hundreds of different calculations involved and would like for my app's admins to be able to tweak these calculations by specifying the formulas.

For example, my database table contains price and quantity. One of the columns 'X' might contain "(price * quantity) over the past 7 days". How can I allow my app's admins to change the calculation from "7 days" to "14 days"?

Is there some way to make calculations dynamic within VB.NET or do I have to rely on stored procedures and write some code to alter those procedure if a change is needed? What are the best practices in this type of a scenario?

Ideally, I would like to use something similar to the "Tags" box used when posting questions on here to bring up the available fields and add mathematical operators in between them to perform calculations. It might be adding more complexity, but would be great if an existing calculation isn't overwritten so that it could be used in building a new formula.

Any help would be much appreciated. Thanks!

Robert Harvey · Accepted Answer · 2012-06-11 22:58:02Z

1

You could use an eval function, like the one described here or here.

Make sure you implement it in a way that is safe. Allowing users to execute arbitrary code can be dangerous, for obvious reasons.

answered Jun 11, 2012 at 22:58

Robert Harvey

182k48 gold badges349 silver badges516 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fenix2222 · Accepted Answer · 2012-06-11 23:06:44Z

0

Windows Workflow has a nice "Rules" feature which is an XML based rule definitions

http://msdn.microsoft.com/en-us/library/aa480193.aspx http://stackoverflow.com/questions/1017056/parse-and-execute-formulas-with-c-sharp

You could utilise it. Alternatively you could build your own XML based formula engine. Similar to this one:

http://www.codeproject.com/Articles/25578/Dynamic-Formula-Processing-Library

edited Jun 11, 2012 at 23:06

answered Jun 11, 2012 at 22:52

fenix2222

4,7504 gold badges39 silver badges56 bronze badges

Collectives™ on Stack Overflow

ASP/VB/C# .NET Dynamic Calculations & Referencing

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related