working with date type

H

Hasan

New member
Joined
Jan 16, 2005
Messages
2
Location
Karachi, Pakistan
Hello I am using VB.Net to develop Order Processing Form. I have a field called EDD Expected Delivery Date I want to have the option of leaving this field blank if I dun have any expected delivery date. The Problem arrrives when I save the order to the SQL database as it doesnt accept Null vales

How should I handle a situation like this ? How can I save Blank or Null value to my SQL Server Databse using DateTimePicker Control on Windows Forms? Please any help would be appreciated!
 
What flavor of SQL are you using? if it is MS SQL Server go to enterprise manager and go to design table and make sure you have the check box that allows nulls. then you should have no problem passing in a null value.
 
Back
Top