Re: Passing Null value to SQL
From: Sriram Krishnan (ksriram_at_NOSPAMgmx.net)
Date: 10/21/04
- Next message: amber: "Re: Passing Null value to SQL"
- Previous message: Sriram Krishnan: "Re: XP visual style"
- In reply to: amber: "Passing Null value to SQL"
- Next in thread: amber: "Re: Passing Null value to SQL"
- Reply: amber: "Re: Passing Null value to SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 21 Oct 2004 22:02:46 +0530
Try using DBNull
-- Sriram Krishnan http://www.dotnetjunkies.com/weblog/sriram "amber" <amber@discussions.microsoft.com> wrote in message news:129004EF-3C97-4424-A70D-9A338BF7D543@microsoft.com... > Hello, > I'm not sure if this question should go in the SQL forum or this one... > > 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?? > > Thanks! > amber
- Next message: amber: "Re: Passing Null value to SQL"
- Previous message: Sriram Krishnan: "Re: XP visual style"
- In reply to: amber: "Passing Null value to SQL"
- Next in thread: amber: "Re: Passing Null value to SQL"
- Reply: amber: "Re: Passing Null value to SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
