how to get sum from data table?

Question

1.00/5 (2 votes)

See more:

I have a data table. how to add sum function to this query?

C#

var qry = from rows in dtTempTbl.AsEnumerable()
                                 orderby rows["RowId"] ascending
                                 group rows by new { PositionID = rows["ItemSubGroupId"] } into grp
                                 select grp.First();

Posted 4-Dec-14 1:21am

amnk.info

Add a Solution

Comments

Tomas Takac 4-Dec-14 7:33am

Sum of what? Could you be more specific?

3 solutions

Solution 1

Hi,

MSDN has a great site where you can find many useful LINQ examples.

https://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869[^]

Cheers!

Posted 4-Dec-14 1:32am

Marcin Kozub

Updated 4-Dec-14 2:18am

v2

Comments

BillWoodruff 4-Dec-14 7:55am

Congratulations on your great recent track record in providing many useful answers here on QA !

In this case, without knowing more from the OP, is this reply of yours really a "solution" ?

Marcin Kozub 4-Dec-14 8:51am

In this case personally I think that one quick look at examples on that msdn website can give OP very useful hint how to solve his/her problem. I used this site to learn linq by myself.

And thx for a good word, I'm doing my best to help.

amnk.info 4-Dec-14 23:13pm

thanks i found it from that site

Marcin Kozub 5-Dec-14 6:11am

You're welcome.

Solution 2

You haven't provided enough information about what you are trying to do, so with that in mind all I can do is send to you towards an example on the MSDN site.

Sum - Grouped[^]

If this isn't what you are after then please edit your question and provide as much detail as you can, including some code that you have tried etc.

Posted 4-Dec-14 3:24am

Simon_Whale

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kan07 · Accepted Answer · 2014-12-04T18:42:00

Solution 3

datble.Compute("sum(RATE)", "1=1")); //where rate is a column inside the datatable

Posted 4-Dec-14 18:42pm

Kan07

Comments

amnk.info 5-Dec-14 1:36am

thanks for replying me. your answer also worked.