Hi, I have a datetime column in my SQL Server DB table an have some records with a value of NULL. I am trying to load an object with date values. Because the date is null my variable has a value of "12:00:00". How can I ensure that my Date variable is "" instead of the "12:00:00" which causes a SqlDateTime overflow exception. My variable is set up as a Nullable(Of Date) but I have just been having so many problems with Null dates in VB.NET. What is the best procedure for working with null dates?
VB.NET and SQL datetime
- Thread starter ringo747
- Start date
Yes I have them declared as a date type at the minute but maybe it should be nullable(of date) ?? I have code that looks exactly like yours except instead of object it is Date.
I think the problem lies in the fact that even though the DB contains NULL there is a time value appears in the Date object. I think on loading the object I will have to check for null dates but i don't think this is possible unless the date object is made nullable. Im newish to .net so not sure on this really.
I think the problem lies in the fact that even though the DB contains NULL there is a time value appears in the Date object. I think on loading the object I will have to check for null dates but i don't think this is possible unless the date object is made nullable. Im newish to .net so not sure on this really.
yeah I guess that could work well. I just don't understand why it currently shows just a time in the date field when in the db the value is null. Will have a look again at nullable objects.
I am right in thinking that if you want to allow null values for an object then you must use nullable in the property definition? Therefore if I don't want to allow nulls then I just define the object as type date?
I am right in thinking that if you want to allow null values for an object then you must use nullable in the property definition? Therefore if I don't want to allow nulls then I just define the object as type date?
Last edited: