Re: Passing a null value as date to SQL
From: Bernie Yaeger (berniey_at_cherwellinc.com)
Date: 10/25/04
- Next message: James Jenkins: "Re: Fast Database access required"
- Previous message: Miha Markic [MVP C#]: "Re: Passing a null value as date to SQL"
- In reply to: amber: "Passing a null value as date to SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 25 Oct 2004 14:55:31 -0400
Hi Amber,
cLP.DateApproved = DBNull.value
should work.
HTH,
Bernie Yaeger
"amber" <amber@discussions.microsoft.com> wrote in message
news:5FC5EF9B-56D1-41EE-AB42-40C1E5954435@microsoft.com...
> 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
>
- Next message: James Jenkins: "Re: Fast Database access required"
- Previous message: Miha Markic [MVP C#]: "Re: Passing a null value as date to SQL"
- In reply to: amber: "Passing a null value as date to SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
