Get sum from a DataColumn values in C#

c# sum datacolumn
hamze picture hamze · Oct 10, 2011 · Viewed 7.5k times · Source

I have a table in a dataadapter. I want to get the count and sum of a specific column of it. How is that possible?

  • This is the code for reach to the column, what after that?

    DataColumn buy_count = myDataSet.Tables["all_saled"].Columns["how_much_buy"]

I know that we have sum, count,... in SQL, but how can I do it in C#?

Answer

Anas Karkoukli picture Anas Karkoukli · Oct 10, 2011

You can use LINQ to DataSets

var sales = myDataSet.Tables["all_saled"].AsEnumerable();

var buy_total = sales.Sum(datarow => datarow.Field<int>("how_much_buy"));

Check the LINQ to DataSets 101 Samples

P.S. might need the System.Data.DataSetExtensions assembly referenced.

Related questions

How can I get a sum for the column "pieces" in a datatable?

How can I get a sum for the column "pieces" in a datatable? Say I had the following table. How can I calculate the "total" pieces for article="milk" and artno="15"? Columns: article artno pieces Rows: 1 milk 15 1 2 water 12 1 3 apple 13 2 4 milk 15 1 5 …

Read More
C# List of objects, how do I get the sum of a property

I have a list of objects. One property of the individual object entry is amount. How do I get the sum of amount? If my list was of type double I may be able to do something like this: double …

Read More
How to calculate sum of a DataTable's Column in LINQ (to Dataset)?

I'm just started to read up on LINQ and I want to start incorporating it into my code. I know how to compute the sum of a DataTable's column by either "Foreach"-ing through the rows or by doing a …

Read More