I'm trying to filter on null columns (I only want to show rows where the column is null), but the issue is I can't compare the column to 开发者_运维技巧a null, since the column is of DateTime value.
I get the following error
System.Data.EvaluateException: Cannot perform '=' operation on System.DateTime and System.String.
This is my code for the filter
CourseID IN (" + courseIds + ") AND Isnull(DateBooked, 'Null Column') = 'Null Column'
DateBooked is the column with DateTime value. Everything before the Isnull is functioning correctly. Help please!
Doesn't isnull always return a value of the same type as its first parameter?
Try DateBooked IS NULL instead of Isnull(DateBooked, 'Null Column') = 'Null Column'.
加载中,请稍侯......
精彩评论