Issue with typed date value with value set date

Question

I have a datatatable in a typed dataset with a date column. When I change the NullValue property to return null or empty, vs 2008 will not allow me.

it says The value entered is not valid for the current data type.

I need to be able to set null values ​​in this column.

Answer 1

If you use typed datasets, you can determine that the column is NULL ( AllowDBNull ). If this property is set to true, you can use the methods yourDataRow.SetFieldnameNull() and yourDataRow.IsFieldnameNull() (of course, you have to replace Fieldname with the name of the field with a null value)