Defining formula through user interface in user form
Posted
by
BriskLabs Pakistan
on Programmers
See other posts from Programmers
or by BriskLabs Pakistan
Published on 2012-09-09T15:21:55Z
Indexed on
2012/09/09
15:48 UTC
Read the original article
Hit count: 260
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.
e.g
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
Problem:
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.
© Programmers or respective owner