Table Adapters / Null Values

[Microsoft Newsserver]

Hi.

I have a table adapter and one of the column s is a DateTime field. The
underlying table allows for nulls and this is reflected in the properties
for this column in the table adapter. However, I need to use an insert
function and set the value to a null.

I have tried using myTableAdaper.MyColumnName = DBNull.value;
( does not allow a cast from null to date time )

And also using plain old 'null'.

How can i set the value of this column to a null. basically, If the user
does not fill in the date field, then I want the value to be null.