c# datatable add where condition on array of string

Question

This is my 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)) - epoch).TotalMilliseconds
                         }).ToList();

where InBoundtable is a datatable.

now I have a string array campains

my question is there a way so in the select statement above I can make where the campain field, which is a string field, is either one of the values in the campains array?

Tim Schmelter · Accepted Answer · 2014-08-05 21:32:55Z

1

You can use Enumerable.Contains("campain value"):

var query =  from row in InBoundtable.AsEnumerable()
             where campains.Contains(row.Field<string>("Campain"))
             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)) - epoch).TotalMilliseconds
             };
var result = query.ToList();

edited Aug 5, 2014 at 21:32

answered Aug 4, 2014 at 9:42

Tim Schmelter

462k79 gold badges721 silver badges981 bronze badges

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

4 Comments

Tim Schmelter Over a year ago

@MarcoDinatsoli: note that i've edited the answer since you should exclude rows before the group by.

Marco Dinatsoli Over a year ago

that is what I was going to ask you about. I am trying it

Marco Dinatsoli Over a year ago

if the array of string is empty, will that code throw exception? or just empty result?

Tim Schmelter Over a year ago

@MarcoDinatsoli: it won't throw an exception if it's empty, only if it's null. Read: msdn.microsoft.com/en-us/library/bb352880(v=vs.100).ASPX

Collectives™ on Stack Overflow

c# datatable add where condition on array of string

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