LINQ Group by with where condition in Data table using C# asp.net

Question

I am very new in LINQ and trying group by with where condition.

Below is my code working fine without where condition.

 List<DataTable> result = dt.AsEnumerable()
      .GroupBy(x => x.Field<int>("row_Id")) 
      .Select(grp => grp.CopyToDataTable())
      .ToList();

In my datatable dt getting this data.

 row_id         name
  0              Mazhar
  0              Raj
  1              Khan
  1              Ravi

I need to separate row_id=0 and row_id=1 data.

it would be better if you could describe what you are trying to do (rather than what the code should look like) — M.kazem Akhgary
– M.kazem Akhgary, Commented Jul 7, 2018 at 9:55
in my dt I am getting data with row_id=0 and row_id=1. So I am trying to separate row_id=0 and row_id=1 data and row_id are fixed in [email protected] — Mr doubt
– Mr doubt, Commented Jul 7, 2018 at 9:59
Why do you need the where condition? GroupBy does what you explained. — L_J
– L_J, Commented Jul 7, 2018 at 10:14
List<DataTable> result = dt.AsEnumerable().Where(x => x.Field<int>("row_Id") == 0) .GroupBy(x => x.Field<int>("row_Id")) .Select(grp => grp.CopyToDataTable()) .ToList(); i got my answer from my self.@L_J — Mr doubt
– Mr doubt, Commented Jul 7, 2018 at 10:29

Bob K · Accepted Answer · 2018-07-07 10:39:41Z

1

The .Where clause below would filter results where rowId = 0.

List<DataTable> result = dt.AsEnumerable()
  .Where(w => w.Field<int>("row_Id") == 0)
  .GroupBy(x => x.Field<int>("row_Id")) 
  .Select(grp => grp.CopyToDataTable())
  .ToList();

answered Jul 7, 2018 at 10:39

Bob K

4803 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

L_J Over a year ago

After the Where the GroupBy does nothing.

Bob K Over a year ago

What do you want the result to look like after filtering by one of the IDs?

D3ivid · Accepted Answer · 2018-07-07 12:37:10Z

0

        var result = dt.Rows.Cast<DataRow>( )
                            .Select( x => new { ID = x.ItemArray[0], ROW = x } )
                            .GroupBy( x => (string)x.ID )
                            .ToList( );

This LINQ separates row_id = 0 to row_id = 1. If you need a iEnumerable of DataRow:

        var result0 = result.Where( x => (string)x.Key == "0" ).FirstOrDefault( ).Select( x => x.ROW ).ToList( );
        var result1 = result.Where( x => (string)x.Key == "1" ).FirstOrDefault( ).Select( x => x.ROW ).ToList( );

answered Jul 7, 2018 at 12:37

D3ivid

612 bronze badges

Collectives™ on Stack Overflow

LINQ Group by with where condition in Data table using C# asp.net

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related