How Datatable use LINQ after groupby then select by some condition to copy to new datatable?

Asked Dec 06 '18 at 02:42

Active Dec 06 '18 at 05:55

Viewed 39 times

I have a DataTable as follow,

SN   NO  NAME
----------------
a1   1   AA12
a1   2   BB34

How can I use LINQ let this DataTable group by SN and then select where to fill new table like this?

SN   NAME1  NAME2
------------------------
a1   AA12   BB34

I try use group by then where ans select by LINQ, but still fail..Can someone help me? Thanks.

edited Dec 06 '18 at 05:55

asked Dec 06 '18 at 02:42

Wei Ying Huang

You are creating a pivot, have a look at: https://stackoverflow.com/questions/167304/is-it-possible-to-pivot-data-using-linq – peeyush singh Dec 06 '18 at 03:16
Is it LONQ or LINQ? – ManirajSS Dec 06 '18 at 04:30
I'm sorry, my mistake. – Wei Ying Huang Dec 06 '18 at 05:56

0 Answers0