How to Calculate Decimal values of All Rows From a Table in

Paul Rajs

9y798.NET

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);

da.Fill(dt);

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

Thanking You

Paul.S

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Accepted answer
@Rafnas,

To be correct, it has to be:

Sum(isnull(quantitydespatched, 0.00))
+4
Paul Rajs9y ago
i got exact output friends .
howecer thanks a lot for all your valuable reply dear friends and brothers

by
Paul.S
+1
Rafnas T P9y ago
check in table is there any null or empty field in quantitydespatched column then try below code

SqlCommand cmd = new SqlCommand("[select Sum(isnull(quantitydespatched,'0')) from Sales where Totalsales='"Ses_Sales""']", con);
+2
Amit Gupta9y ago
What error you are getting?
dt.Compute (..) function performs all types of arithemetic calculations, its probably the problem with the datatype of the column.
+3
Nitin Sontakke9y ago
What is the data type of QuantityDespatched column in the Sales table? And another question is why are you getting data in data table and doing the sum?

Why not sum it at server side itself. Neat, clean and fast.

select sum(QuantityDespatched) SumQuantityDespatched
from Sales
where TotalSales = 'Ses_Sales'
+1