asked on
myCommand.Parameters.Add with a NULL value in a smalldatetime field
Hello Experts,
I'm having dramas inserting null a null value into my database smalldatetime field.
I check the fields first on the form
Dim strDate As String
If Trim(myDay) = "" Or Trim(myMonth) = "" Or Trim(myYear) = "" Then
strDate = System.DBNull.Value.ToStri
Else
myCommand.Parameters.Add("
For some reason if there is a value my code works, but the System.DBNull.Value.ToStri
Any help?
Cheers
Don
I'm having dramas inserting null a null value into my database smalldatetime field.
I check the fields first on the form
Dim strDate As String
If Trim(myDay) = "" Or Trim(myMonth) = "" Or Trim(myYear) = "" Then
strDate = System.DBNull.Value.ToStri
Else
myCommand.Parameters.Add("
For some reason if there is a value my code works, but the System.DBNull.Value.ToStri
Any help?
Cheers
Don
.NET ProgrammingDatabasesASP.NET
Last Comment
Fareed Ali Khan
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
just find and replace
It is actually in a function that is across the entire site. It drops dates into SQL and it is used for parameters.
Is there a way I can get it to do both with out changing all of the places it is used?
Cheers
Don