Vartana
asked on
Sum of Dataset column
I have a data set called MyDataSet
Then i have a datatable called MyDataTable
I want to get the sum of column 3
How would I do this ?
Thank You
Then i have a datatable called MyDataTable
I want to get the sum of column 3
How would I do this ?
Thank You
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
put criteria for filter that will match all the records.
FOr example you want to calculate quantity
objSum = myTable.Compute("Sum(Qty)" , "Qty>0")
FOr example you want to calculate quantity
objSum = myTable.Compute("Sum(Qty)"
also you can use Nothing for filter
objSum = myTable.Compute("Sum(Qty)" , Nothing)
objSum = myTable.Compute("Sum(Qty)"
ASKER
How can i do it without filtering