Total salary for department wise group by concept using linq in asp.net

Question

I am new to linq query in Asp .Net. I want total salary for department wise using group by concept. I want result using linq query so please help me friends. I have taken one table see below. Can you please give a solution for my query? I had tried but I didn't find out the solution.

My data table is:

    id   name     dept   sal
     1   ABC      it    10000
     2   BBC      it    20000
     3   CCA      hr    30000
     4   DDA      hr    40000
     5   MMN      admin 50000

Result like:

       dept   sal  
      ----------------- 
       It    30000
       Hr    70000
       Admin 50000

score 2 · Answer 1 · answered Oct 18 '13 at 10:25

2

Hi it should not be that difficult to get what you want.

tablename.GroupBy(g => g.dept)
.Select(s => new {
       dept = s.Key,
       sal = s.Sum(t => t.sal)
       })
.ToList();

And this gives you a list of total salary for each department

answered Oct 18 '13 at 10:25

Raphael

1,677
1
15
23

It shows an error at GroupBy.there is no propety GroupBy for datatable. – user1858830 Oct 18 '13 at 11:06
it is possible to see the code you wrote? it's strange because that the code that I use to do my group by sums – Raphael Oct 18 '13 at 11:26

score 0 · Answer 2 · edited May 23 '17 at 12:09

0

somethink like this:

context.table.GroupBy(t => t.dept, e => e.sal).Select(r => new { key = r.Key, sum = r.Sum(x => x) });

Edit:

For using linq with dataTable add a reference to System.Data.DataSetExtensions and add System.Data namespace and call AsEnumerable() to your dataTable. Also take a look at Here

edited May 23 '17 at 12:09

Community

1
1

answered Oct 18 '13 at 10:28

MRB

3,752
4
30
44

score 0 · Answer 3 · answered Oct 18 '13 at 10:29

0

you can do something like this ..

var list = table.GroupBy(p=>p.dept,q=>q.sal).Select(x=>new { dept = x.Key, sal = x.Sum(s=>s.sal)});

answered Oct 18 '13 at 10:29

Sandeep Chauhan

1,313
1
10
23

It shows an error at GroupBy.there is no propety GroupBy for datatable. – user1858830 Oct 18 '13 at 11:07

score -1 · Answer 4 · answered Oct 02 '18 at 21:16

        List<Student> studentsList = new List<Student>()
        {
           new Student(){Id = 1,Name ="krish",Gender="male",City="ahmedabad",Salary=2750},
           new Student(){Id = 2,Name ="rahul",Gender="male",City="delhi",Salary=1000},
           new Student(){Id = 3,Name ="neha",Gender="female",City="surat",Salary=2500},
           new Student(){Id = 4,Name ="dev",Gender="male",City="mumbai",Salary=7800},
           new Student(){Id = 5,Name ="priya",Gender="female",City="ahmedabad",Salary=5600},
        };

        var queryList = from SL in studentsList group SL by SL.Gender into GROUPGENDER orderby GROUPGENDER.Key select GROUPGENDER;
        foreach(var studentList in queryList)
        {
            Console.WriteLine(">>>>>group by<<<<<");
            Console.WriteLine(studentList.Key);
            Console.WriteLine(">>>>>group by<<<<<");
            foreach (var item in studentList)
            {
                Console.WriteLine(item.Id);
                Console.WriteLine(item.Name);
                Console.WriteLine(item.Gender);
                Console.WriteLine(item.City);
            }                    
        }                     
        Console.Read();

Welcome to Stack Overflow. While this code may answer the question, providing additional context regarding why and/or how this code answers the question improves its long-term value.[How to Answer](https://stackoverflow.com/help/how-to-answer) — Elletlar, Oct 02 '18 at 21:27

Total salary for department wise group by concept using linq in asp.net

4 Answers4