In my application, I need to allow my users to enter a mathematical script via the user interface. This script will include a combination of database columns, file fields, numerical operators, and numerical values, and will initially be held in the Text property of a TextBox.
I then need to embed that script into code, so it can be run multiple times within a batch process, but I have no idea how to do that. Can anyone suggest how I can make this work? Please note that I can't use SQL scripts as the input scripts aren't necessarily related to database processing.
Note that I will be restricting what a user can input by forcing them to enter the script using options on the screen i.e. through dropdown lists and buttons, so I know that what comes in will be syntactically correct.
I don't even know where to start on this one, so any help is greatly appreciated