Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Linq with Two Table GroupBy sum column and row in asp.net co
U Thu
Dec 30 2017 11:11 PM
179
Reply
my budget allocation example table is Id Year Powerplant BudgetWorkOne BudgetWorkTwo 1 2017 p1 100 200 2 2017 p2 300 400 3 2018 p1 500 600 4 2018 p2 700 800 My usage budget table is Id Year Powerplant BudgetCategory Usedamount 1 2017 p1 BudgetWorkOne 100 2 2017 p1 BudgetWorkTwo 150 3 2017 p2 BudgetWorkOne 500 4 2017 p2. BudgetWorkTwo 300 5 2018 p1 BudgetWorkOne 600 6 2018 p1 BudgetWorkTwo 500 7 2018 p2 BudgetWorkOne 200 8 2018 p2. BudgetWorkTwo 300 I want yearly with result groupby powerplant name. Id year power AW1 UsedW1 DifW1 AW2 UsedW2 DifW2 1 2017 p1 100 100 0 200 150 50 2 2017 p2 300 500 -200 400 300 100 Columnsum 400 600 -200 600 450 150 How to create class and write for me.Please help me sirs.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Finding difference in two strings.
How to fetch master detail data using EF and LINQ