DBNull error

[kanchoette]

Although I have all datatable columns set to accept DBNull, my application throws this exception:

[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.DateTime ArrangementDate {
get {
try {
return ((global::System.DateTime)(this[this.tablePaymentArrangements.ArrangementDateColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'ArrangementDate\' in table \'PaymentArrangements\' is DBNull.", e);
}
}
set {
this[this.tablePaymentArrangements.ArrangementDateColumn] = value;
}
}

I'm stumped (right now). Any pointers would be much appreciated please.

[J4amieC]

If that is a strongly typed dataset, you'll find it has an bool IsArrangementDateNull() method. You should use this to check before trying to read the value. The reason for this is there is no way to cast DBNull.value to a DateTime.

[monstale]

Hi, I think DBNull is not compatible with DateTime. You should check if it is DBNull.Value and then send null back. ;-) greetz

[PIEBALDconsult]

DateTime is not nullable.