c# - Comparing DateTime variable to DateTime data type column with Null values in it -
i have c# search on records in array sql server db using 3 data elements. 1 of data elements has datetime element in column called dateofbirth. unfortunately there lot of null values in column , can't figure out how compare datetime variable field null values. see lot of answers appear close need here, nothing has helped. help, has been format.
if ((datetime)dt == (datetime)temp[i].individual.dateofbirth) globalnum3.bnum3 = 1;
i'm assuming dt datetime, in case can't null (datetime struct) , there's no need cast it.in addition, either temp[i].individual.dateofbirth datetime , cannot null either, or it's nullable<datetime>.
assuming both datetimes, db nulls set datetime.minvalue, compare values:
if (dt == (datetime)temp[i].individual.dateofbirth) { globalnum3.bnum3 = 1; } however, if temp[i].individual.dateofbirth nullable<datetime>, might null, or might have no value, use this:
var possibledateofbirth = temp[i].individual.dateofbirth; if (possibledateofbirth != null && possibledateofbirth.hasvalue && dt == possibledateofbirth.value) { globalnum3.bnum3 = 1; }
Comments
Post a Comment