I am working on a vb.net 2005 project using sql server 2000 as the backend .
I am having a bit of problems with date variables... Here is the scenario...
I have a table that includes a couple "smalldatet ime" fields.
In my class for this table, when inserting new or saving a row in the table,
both of these date values may possibly be empty. (ie I am allowing nulls on
the db side... )
On an initial insert what is happening is that in my class I have a property
defined as type 'Date'. This 'Date' variable's value (field called
"dtOfferValidUn til") is then used in the stored procedure that inserts or
updates the table as a passed in parameter. What I have discovered is that a
"date" field's initiall value is something along these lines... "#12:00:00
AM#". So, when my stored procedure executes and an attempt is made to set my
smalldatetime field to this value, an error is generated that says
"SqlDateTim e overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999
11:59:59 PM".
My question is this... I want the date property in my class to be initially
set to null somehow so that the date being passed into the stored procedure
will just be null and not "#12:00:00 AM#"... In fact, what I want is to do a
check for a valid date in my class and if it is a valid date, then I will
pass that value onto the stored procedure - otherwise I want to set the date
variable to null and pass that value in. My SQL stored procedure checks for
null values before updating the field. If it is null, then the original
value is left there. If it is not null then the field is updated.
What is the best way to go about doing this? I hate dates...
Thanks, Brad
I am having a bit of problems with date variables... Here is the scenario...
I have a table that includes a couple "smalldatet ime" fields.
In my class for this table, when inserting new or saving a row in the table,
both of these date values may possibly be empty. (ie I am allowing nulls on
the db side... )
On an initial insert what is happening is that in my class I have a property
defined as type 'Date'. This 'Date' variable's value (field called
"dtOfferValidUn til") is then used in the stored procedure that inserts or
updates the table as a passed in parameter. What I have discovered is that a
"date" field's initiall value is something along these lines... "#12:00:00
AM#". So, when my stored procedure executes and an attempt is made to set my
smalldatetime field to this value, an error is generated that says
"SqlDateTim e overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999
11:59:59 PM".
My question is this... I want the date property in my class to be initially
set to null somehow so that the date being passed into the stored procedure
will just be null and not "#12:00:00 AM#"... In fact, what I want is to do a
check for a valid date in my class and if it is a valid date, then I will
pass that value onto the stored procedure - otherwise I want to set the date
variable to null and pass that value in. My SQL stored procedure checks for
null values before updating the field. If it is null, then the original
value is left there. If it is not null then the field is updated.
What is the best way to go about doing this? I hate dates...
Thanks, Brad
Comment