yepp, thanks! I've found the solution here - really good explained!! : http://vbnotebookfor.net/2007/09/27/introduction-to-nullable-types-in-vbnet/
=) On 4 Mai, 22:34, Ricardo Peres <[email protected]> wrote: > Have you heard of nullable types? > > Protected nullableField As Nullable(Of DateTime) > > On May 4, 8:09 am, foruminar <[email protected]> wrote: > > > > > > > > > Hello there > > > I'm using VB.NET and MySQL. > > I have a datetime attribute which has either a date or null in the > > database. In VB.Net the type of the variable is Date. > > > In case that I insert a new data set, I need for my attribute the > > value null. > > If I set this varbiable in VB.NET to "Nothing" or to > > DateTime.MinValue, the value of my variable is "#12:00:00 AM#". If I > > use the type SqlTypes.SqlDateTime, I'll get the error that the value > > has to be between 1/1/1753 12:00:00 AM and12/31/9999 11:59:59 PM. > > > In the next step I need the data set with the null datetime in VB.Net. > > But I get this "#12:00:00 AM#" instead of nothing/null. > > > Does anybody know, how to set the attribute of the new data set to > > null and how to get the null/nothing value in VB.Net back? > > > Lots of thanks for any help! -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
