how to Store Math Formula in sql server

Question

1.00/5 (3 votes)

See more:

I Wanted to store the formula text and intend to evaluate the formulae and display results of the operation..
Please help me!
Thanks a lot

Posted 18-Nov-12 4:48am

sadat_prog

Add a Solution

Comments

OriginalGriff 18-Nov-12 11:24am

And? Your problem is?
What have you tried? What have you got to store so far? Where are you stuck?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Answer 1 · 2014-05-22T19:24:00

you can do this way...

store formula in sql table tblFormulas like below...

FormulaName  			FormulaEquation
Gain				S.P. - C.P.
Loss				C.P. - S.P.
Gain%				(GAIN * 100)/C.P.
Loss%			         (LOSS * 100)/S.P
Selling Price (S.P)                 ((100 + GAIN%)/100)*C.P.

Now...
Write down code in .net
replace values of parameters in equations...
for e.g.

C#

string Equation = "((100 + GAIN%)/100)*C.P."; 
Equation = Equation.Replace("GAIN%", txtGainPer.text); // suppose txtGainPer.text = 50
Equation = Equation.Replace("C.P.", txtCP.text); // suppose txtGainPer.text = 27
Equation = Equation.Replace("S.P.", txtSP.text);
Equation = Equation.Replace("GAIN", txtGain.text);
Equation = Equation.Replace("LOSS", txtLoss.text);
//result will be like below... Equation = "((100 + 50)/100)*27";
//now send this equation to sql as below to evaluate
Equation = "Select " + Equation;
//then pass string to sql for execution...

NOTE : This code is vulnerable for sql injection
TIP: to avoid this you can use third party .net classes available for evaluate expressions OR can write code for evaluate expressions your self

Hope this helped you.
Happy Coding!
:)

Subrata.In · Answer 2 · 2012-11-18T05:52:00

Solution 1

If I am not wrong; you want to store some sql in a field and execute it.

Check this it may help you.

SQL

Declare @a varchar(999)

set @a='select 5*5+5'
--You can use select @a=fieldname from tablename where criterya

Exec (@a)

Posted 18-Nov-12 5:52am

Subrata.In