Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Have issue with typed dataset nullable date value

I have a datatable in a typed dataset with a date column When I change the NullValue property to return null or empty , vs 2008 wont let me.

it says

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

I need to be able to set null values por this column.

like image 227
Luis Valencia Avatar asked Aug 23 '11 12:08

Luis Valencia


1 Answers

If you use typed datasets, you can define that the column is nullable (AllowDBNull) If this property is set to true, you can make use of the methods yourDataRow.SetFieldnameNull() and yourDataRow.IsFieldnameNull() (of course, you have to replace Fieldname with the name of your nullable field)

like image 111
Stephan Bauer Avatar answered Nov 09 '22 06:11

Stephan Bauer