hi please help me on this how to convert string to decimal

Question

Hi, please see code below string strValue="(1000*15)/100"; decimal calculatedValue=convert.toDecimal(strValue); it is giving a error I want ot convert string of formula containing values to decimal

Vulpes · Answer

What you're trying to do is not possible because methods such as Convert.ToDecimal etc, do not recognize arithmetic operators such as *, +, - and /. If you're trying to do this for arbitrarily complex expressions, then you need to use an Eval() function such as the one provided by VBScript which can be used from C#. To do this, start a new console application project in VS and add a reference to the Microsoft Script Control 1.0 which can be found under the COM tab. Now enter the following code, build and run: using System; using MSScriptControl; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { var sc = new ScriptControl(); sc.Language = "VBScript"; string strValue="(1000*15)/100"; decimal calculatedValue = (decimal)sc.Eval(strValue); Console.WriteLine("Result: " + calculatedValue); Console.ReadKey(); } } } The output should be: Result: 150

Kunal Vaishya · Answer

Please Check this sample Attached and Link Also http://www.codeproject.com/Articles/30999/ScriptEngine-User-Defined-Calculations-in-C-VB-JSc

Mallesh · Answer

Hi, Thank very much its working fine

hi please help me on this how to convert string to decimal

Answers (3)