I am a student and developing a simple assignment - windows form application in visual studio 2010.
The application is suppose to construct formulas as per user requirement.
The process: It has to pick data from columns of Microsoft Access database and the user should be able to pick the data by column name like we do in a drop down menu. and create reusable formulas in it ( configure it once and can change it again). followings are column titles from database that can be picked for example.
Col -1 : Marks in Maths Col -2 : Total Marks in Maths Col -3 : Marks in science Col -4 : Total marks in science
Finally we should be able to construct any formula in the UI like
(Col 1 + Col 3 ) / ( col 2 + col 4) = Formula 1
once this is formula is set saved and a name is assigned to it by user. he/she can use the formula and results shall appear in a window below.
i.e He would be able to calculate his desired figures (formula) by only manipulating underlying data on the UI layer....choose the data for a period and apply the formula and get the answer
It looks like I have to create an app where rules are set through UI....... this means no stored procedures are required in SQL.... please suggest the right approach.