Link to home
Create AccountLog in
Avatar of Edward
EdwardFlag for United States of America

asked on

LINQ Query of Datatable with grouping Sum to a datatable

I need to Group and sum data from a datatable.

What I reading is I need to use LINQ to do it.

I'm trying to change  This SQL Statement  
SELECT PLANT, PDCATYPE_NAME, Month, Year, STATUS_NAME_REPORT, Sum(SAVINGS_PER_MONTH) AS SAVINGS_PER_MONTH
FROM ADataTable
GROUP BY PLANT, PDCATYPE_NAME, Month, Year, STATUS_NAME_REPORT;

to LINQ so I can query my DataTable object.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of kaufmed
kaufmed
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Edward

ASKER

Thanks,   That was a WHOLE lot easier to understand then what I found doing a google search.
NP. Glad to help  :)