c# datatable group by many columns

Question

This is my old code

DateTime epoch = new DateTime(1970, 1, 1);
var result = (from row in InBoundtable.AsEnumerable()
              group row by row.Field<string>("Date") into grp
              select new
              {
                  AbandonCalls = grp.Sum((r) => Double.Parse(r["AvgAbandonedCalls"].ToString())),
                  Date = ((DateTime.Parse(grp.Key.ToString())) - epoch).TotalMilliseconds
              }).ToList();

as you see, I am making group on Date column.

Can I make the group on Date and Slice columns? where both of them is string value

Grant Winney · Accepted Answer · 2014-08-02 20:26:00Z

1

Create an anonymous type using those two columns. Both columns will be part of the group's "key", so you'll have to access them separately.

DateTime epoch = new DateTime(1970, 1, 1);

var result = (from row in new DataTable().AsEnumerable()
              group row by new
                           {
                               Date = row.Field<string>("Date"),
                               Slice = row.Field<string>("Slice")
                           }
              into grp
              select new
                     {
                         AbandonCalls = grp.Sum((r) => Double.Parse(r["AvgAbandonedCalls"].ToString())),
                         Date = ((DateTime.Parse(grp.Key.Date)) - epoch).TotalMilliseconds,
                         grp.Key.Slice
                     }).ToList();

edited Aug 2, 2014 at 20:26

answered Aug 2, 2014 at 20:18

Grant Winney

66.6k13 gold badges120 silver badges167 bronze badges

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

4 Comments

Marco Dinatsoli Over a year ago

why did you remove the into grp part please?

Marco Dinatsoli Over a year ago

could you please? because you have added new {} which is a new syntax to me

Marco Dinatsoli Over a year ago

I tried this }into grp and no syntax error. I am testing the results

Marco Dinatsoli Over a year ago

sorry for being late, i have other problems, I will update you as soon as possible

Collectives™ on Stack Overflow

c# datatable group by many columns

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related