How to write group by linq query to a dataset?

Question

0.00/5 (No votes)

See more:

I have employee details in DataSet. How to write Linq query to group employees by department and display them in grid?

What I have tried:

var names = from emp in dt.AsEnumerable()
                        group emp by new
                       {
                           ID = emp.Field<int>("UserId"),

                       } into g
                        select new
                        {
                            ID = g.Key.ID,
                        };

Posted 5-Mar-17 23:54pm

Anitha Anu

Updated 6-Mar-17 7:18am

Add a Solution

Comments

Tomas Takac 6-Mar-17 7:09am

Try group emp by emp.Field<int>("UserId") into g.

1 solution

Add a Solution

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

Maciej Los · Answer 1 · 2017-03-06T07:18:00

Solution 1

If you would like to group data by department, you have to use proper field, such as DepartmentID:

C#

var names = dt.AsEnumerable()
    .GroupBy(emp=>emp.Field<int>("DepartmentId"))
    .Select(grp=> new
        {
             DeptId = grp.Key,
             //define other fields here
        });

For further details, please see:
101 LINQ Samples in C#[^]
Linq 101 lambda samples[^]

Posted 6-Mar-17 7:18am

Maciej Los

Comments

Karthik_Mahalingam 6-Mar-17 22:14pm

5 for the links

Maciej Los 7-Mar-17 1:50am

Thank you, Karthik.

How to write group by linq query to a dataset?

1 solution

Solution 1

Add your solution here

Preview 0

How to write group by linq query to a dataset?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us