c# - select rows from a datatable that contain a certain dd/mm

Question

I'm trying to select rows from a datatable that a have a datetime column that contains a certain dd/mm In my windows forms application using C#, how can this be done? I know the expressions are similar to SQL.

DataType of column is datetime, for example: 09/03/2017 13:26:40

so far i have tried the below but it just returns an exception:

string selectExpression = "colDate LIKE '%09/03%'";
DataRow[] rows = dataTable.Select(selectExpression);

Tag the dbms you're using. You've already got one product specific answer... — jarlh, Mar 09 '17 at 09:23
To all the people asking for dbms, this is about DataSets, not some database system. — dotNET, Mar 09 '17 at 09:34
Sorry for any confusion, this a C# winforms program. I am using DataTable.Select() which uses similar queries/expressions to SQL — Paul Alexander, Mar 09 '17 at 09:36

score 1 · Accepted Answer · answered Mar 09 '17 at 09:49

You are getting the exception because you are apply string filter to DateTime. You can use it of the type if colDate is string then I tested your code and its working.

To filter the DataTable column with DateTime type you can use linQ query like given as under.

var rows = dataTable.AsEnumerable().Where(r=>r.Field<DateTime>("colDate").Day == 9
           && r.Field<DateTime>("colDate").Month == 3);

c# - select rows from a datatable that contain a certain dd/mm

1 Answers1