C# - datatable grouping using linq

Question

1.00/5 (1 vote)

See more:

My datatable like

Company	Name	Department
A	Raja	Mechanical
B	Mano	Electrical
A	Mohan	Computer
B	Rajesh	Computer
C	Siva	Robotics
D	Jeeva	Computer
C	Prakash	Electrical
A	Vinoth	Mechanical

I want to group like below

Company	Name	Department
A	Raja	Mechanical
A	Mohan	Computer
A	Vinoth	Mechanical
B	Mano	Electrical
B	Rajesh	Computer
C	Siva	Robotics
C	Prakash	Electrical
D	Jeeva	Computer

Company Name have to group like this. How can i Group that data in datatable using LINQ .. Note : I want to grouping not sorting. Please help me.

What I have tried:

I have tried the below, but its return first row of the grouping data not all. i want all grouped data in datatable

dt.AsEnumerable().GroupBy(row => row.Field<string>("Company")).Select(g => g.First()).CopyToDataTable()

Posted 12-Jul-17 22:50pm

SnvMohan

Updated 12-Jul-17 23:13pm

v2

Add a Solution

Comments

Karthik_Mahalingam 13-Jul-17 5:02am

are you gonna display it in somewhere?

SnvMohan 13-Jul-17 5:06am

s, i have to group that data's and displayed in somewhere else, but i can received datatable like the above

Karthik_Mahalingam 13-Jul-17 5:07am

how many fields does the table has?

SnvMohan 13-Jul-17 5:08am

10 columns

Karthik_Mahalingam 13-Jul-17 5:15am

create a entity class and convert the datatable to list and use linq to group by then display it, Linq to entities will make your job easier.

SnvMohan 13-Jul-17 5:52am

I think its complicated for me, I have received dynamic datasource in a table, i can able to know only the grouping column names. Columns in datasource can be changed

Karthik_Mahalingam 13-Jul-17 6:00am

ok fine, what is the output you needed in screen

Karthik_Mahalingam 13-Jul-17 23:35pm

take distinct of a column and iterate with the data matching to it and then display it on the page

F-ES Sitecore 13-Jul-17 5:03am

You might have to explain what you mean by wanting the data grouped, according to your examples you just want to order on the Company field.

SnvMohan 13-Jul-17 5:08am

I want to group the data's based on company name, not sorting in company name

Richard Deeming 14-Jul-17 11:31am

But your "I want to group like below" example shows the data sorted, NOT grouped.

Click "Improve question" and update the question to show us what you actually want as the output.

1 solution

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)

OriginalGriff · Answer 1 · 2017-07-12T23:13:00

You don't normally reorder (sort) a DataTable - and that's what your example shows, Grouping is a different and more complex operation - instead to reorder the view of that data as part of your presentation layer, or order the data before it arrives at the DataTable but using ORDER BY as part of your original SQL query. Assuming this is WinForms, look at the DataGridView.Sort Method (DataGridViewColumn, ListSortDirection) (System.Windows.Forms)[^] or investigate the DataView Class (System.Data)[^] which gives you a logt better control over the presentation.