I get data from a table but the 'DateOfBirth' field is shown as null.
So if 'DateOfBirth' is null how can I skip it?
EXCEPTION : Cannot cast DBNull.Value to type 'System.DateTime'. Please use a nullable type
var dd = dx.Tables[0].AsEnumerable().Select(x => new StaffModel
{
userno = x.Field<string>("USERNO"),
dateofbirth = x.Field<DateTime>("DATEOFBIRTH"), // This comes as a DB NULL.
passportno = x.Field<String>("PASSPORTNO"),
passportexp = x.Field<DateTime>("EXPDATE")
});
Try to check for DBNull value in this way:
var dd = dx.Tables[0].AsEnumerable().Select(x => new StaffModel
{
userno = x.Field<string>("USERNO"),
dateofbirth = x["DATEOFBIRTH"] != DBNull.Value ? x.Field<DateTime>("DATEOFBIRTH") : DateTime.MinValue,
passportno = x.Field<String>("PASSPORTNO"),
passportexp = x.Field<DateTime>("EXPDATE")
});
If value is equal to DBNull.Value then set MinValue or whatever you want.
Use a nullable DateTime; DateTime?. In your StaffModel:
public class StaffModel
{
public string userno { get; set; }
public DateTime? dateofbirth { get; set; }
public string passportno { get; set; }
public DateTime passportexp { get; set; }
}
Then when filling that model:
var dd = dx.Tables[0].AsEnumerable().Select(x => new StaffModel
{
userno = x.Field<string>("USERNO"),
dateofbirth = x.Field<DateTime?>("DATEOFBIRTH"), // note the ?
passportno = x.Field<String>("PASSPORTNO"),
passportexp = x.Field<DateTime>("EXPDATE")
});
Date of birth is not a nullable type Your exception would appear to say otherwise.null to a DateTime - only DateTime?. If you want to skip working with that value you would need to add some logic to the code which deals with your resulting IEnumerable<StaffModel>You can check for DBNull.Value
object value = x.Field("DATEOFBIRTH");
if (value == DBNull.Value)
{
// do something
}
else
{
// do something else
}
You need to assign DateTime.MinDate if your variable is not null type.
var dd = dx.Tables[0].AsEnumerable().Select(x => new StaffModel
{
userno = x.Field<string>("USERNO"),
dateofbirth = x.Field<DateTime>("DATEOFBIRTH") ?? DateTime.MinDate,
passportno = x.Field<String>("PASSPORTNO"),
passportexp = x.Field<DateTime>("EXPDATE")
});
