(Sql)DateTime and Null value

M

Matt Jensen

Howdy all
I know this is a common question as I've searched a lot of this NG on the
topic, however I haven't been able to find an answer.
All I want to do is pass a DateTime value to a SQL Server SP DateTime
parameter, and either pass a web form text field value to it if there is one
or else null, I don't want to start another discussion about structs /
datetimes being able to accept nulls, I just would really like it to
work...!

So here is a snippet of what I've tried:

SqlDateTime dateStartDate = SqlDateTime.Null; //(also tried =
System.Convert.DBNull;

if (tbxStartDate.Text!="")
{
dateStartDate = Convert.ToDateTime(tbxStartDate.Text);
}
/*Also tried the following with no success.
else
{
dateStartDate = DBNull.Value;
}*/


//Set SQL parameters and populate with form values
sqlCommand1.Parameters.Add("@StartDate", SqlDbType.SmallDateTime).Value =
dateStartDate;

If you could give me the answer/solution I'd be most happy.
Thanks
Cheers
Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SqlDateTime and DateTime 2
Assigning null value to DateTime 2
Sending Null Value to Sql Server 3
Null and DateTime 8
dealing with null and datetime 12
Failed to convert parameter value from a String to a DateTime 9
String and null vs DBNULL 7
SQL SERVER, DataRows and Null Dates 3

Top