This is my code
var finalResults = (from r in results.AsEnumerable()
where r.Field<DateTime>("PrintTime") is DBNull
where PrintTime is a column in my Sql Server 2008 r2 database, its type is datetime and it is nullable
I got this exception:
Cannot cast DBNull.Value to type 'System.DateTime'. Please use a nullable type.
Could you help please?
DataRow.Field supports nullable types, so use DateTime? instead of DateTime:
var finalResults = from r in results.AsEnumerable()
let printTime = r.Field<DateTime?>("PrintTime")
where !printTime.HasValue
select r;
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments