Use DBNull.Value for datatables/SQL tables.



>I have a DateTime field in a table and sometimes I want to store a blank /null data there (The field is set up in Sql Server to accept nulls)
>I have the following code
>string lcNull = null;
>if (DOC_DATERE.SelectedValue.ToString().Trim() == "")
> {
> DOC_DATERE.SelectedValue = lcNull;
> }
>... but this throws a run time error of:-
> Object Reference not set to an instance of an object.
>If I space out the field I get this error, if there is a valid date there its ok.
>
>Anybody know how to get a null date into the field ?
>
>Regards,
>Gerard