Passing a null value as date to SQL

[Guest]

Hello,

I've been told that the experts here will be able to help me

I'm using VB.NET and SQL Server.
I'm using stored procedures to update and create new records in my database.
On the form I'm working on, I have 2 date fields.
I want the user to have the option of leaving these blank.
I do not want default values.
I'm getting error messages not matter what I try.
What syntax can I use to get VB to pass this null value instead of a date,
into SQL??

I have created a custom class (cLP), which contains two date values
(dateApproved is one).
The column DateApproved in the table is set to accept null values.


If I use the code:
cLP.DateApproved = Convert.DBNull.value

I get the error:

An unhandled exception of type 'System.InvalidCastException' occurred in
microsoft.visualbasic.dll

Additional information: Cast from type 'DBNull' to type 'Date' is not valid.

TIA,

Amber

 

[Miha Markic [MVP C#]]

Hi amber,

DateTime .net type can't be null.
One solution to store nullable type would be to use object instead or
something like
http://sourceforge.net/projects/nullabletypes/
When passing value to a SqlParameter then you have to use DBNull.Value.

 

[Bernie Yaeger]

Hi Amber,

cLP.DateApproved = DBNull.value
should work.

HTH,

Bernie Yaeger