When I use datarow = dataTable.Select(“[ColumnName] LIKE ‘%String%’”) I met the error is: Can’t use LIKE operator to System.Double and System.String.
How can I fix them?
Helpme please!
@Quang_Th_nh_Nguy_n
have a look here:
DataView RowFilter Syntax [C#] for the general syntax
as it has taken two different datatypes for the comparing give a try on:
dataTableVar.AsEnumerable.Where(Function(r) r("ColumnName").ToString.ToLower.Contains(yourStringVar) ).toList
and apply following pattern for handling a possible empty result, just adopt the variable names to your used names:
