I have a problem with filtering data table via column where I have values such as:
X
04/23/2018 00:00:00
FC Done,Please check
When I do it like new_dt = old_dt.Select("[Column] = 'X'").CopyToDataTable it works perfectly.
Unfortunately when I try to filter X and FC Done,Please check like: new_dt = old_dt.Select("[Column] in ('X','FC Done,Please check')").CopyToDataTable I get an error:
What is interesting when I try to filter “FC Done,Please check” with new_dt = old_dt.Select("[Column] = 'FC Done,Please check'").CopyToDataTable I get the same error.
It seems something is wrong with data types or so.
Do you have any idea how I could deal with this problem?
Yes but you should use when your column type is different. so in my example case the column type is by default a string so even if i will omit convert and use only simple column name and string to compare it will work