How to Calculate Decimal values of All Rows From a Table in C#hi Developers ,
i want to know How to Calculate Decimal values of All Rows From a Table in C# .
already i have done following query
SqlConnection con = Connection.DBConn();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("[select * from Sales where Totalsales='"Ses_Sales""']", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
string sum_QuantityDespatched = dt.Compute("Sum(quantitydespatched)", "").ToString();
above query is working fine. But the problem is it is only working with Integer values.
if the values of table have 3 rows
Value = 1=10
Value = 2=20.
Value = 3=30
i got the my expected output is like = 60:
but if i give the decimal values like this
Value = 1=10.50
Value = 2=20.70
Value = 30=30.00
My expected output is 61.20 . but it throws error.
i want to calculate all rows of a table with Decimal Values . How can i done this task .
anyone know how to done this task please suggest me