[Mono-list] Strange Error When Populating A DataSet

David P. Donahue ddonahue@ccs.neu.edu
Tue, 29 Mar 2005 19:03:42 -0500


Well whaddya know, that worked :)

Of course, this came in just in the middle of my compiling and upgrading 
to 1.1.5, as suggested by someone else.  I'd hoped to stay out of the 
development tree for my production server, but everyone seems to be 
agreeing that 1.1.5 is kosher and I could probably use any performance 
increase it brings.  Hopefully my upgrade won't break things now that 
you've fixed my last known bug :)


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



Jorge E. Gonzalez wrote:
> I had the same problem, and I fix whith it:
> 
> Select cast(calldate as char) AS 'thisFieldIsDateTime' from MyTable
> 
> Jorge Eldis
> 
> -----Original Message-----
> From: David P. Donahue [mailto:ddonahue@ccs.neu.edu] 
> Sent: Tuesday, March 29, 2005 4:11 PM
> To: mono-list@lists.ximian.com
> Subject: [Mono-list] Strange Error When Populating A DataSet
> 
> 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
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 
>