[Mono-list] Strange Error When Populating A DataSet

David P. Donahue ddonahue@ccs.neu.edu
Tue, 29 Mar 2005 16:10:59 -0500


When I populate a DataSet from a pretty simple SELECT statement, I 
notice a strange error:

"Cannot set column Date to be null, please use dbnull instead"

This only happens when I include the Date column from the table (of type 
DateTime, naturally), which is somewhat needed in the DataSet.  None of 
the values in the column are null (the database won't allow it).  Also, 
what makes it look even stranger is that, since this DataSet is the 
return value of a web service, I can browse to the service directly and 
see exactly what is being returned.  It looks like it works for a bit, 
but then in the middle of some of the data it adds the error text and 
throws the exception.

Any ideas what might be causing this?  For reference, I'm using Mono 
1.0.6 (or, at least, I should be unless something went wrong when I 
upgraded).


Regards,
David P. Donahue
ddonahue@ccs.neu.edu