(Sql)DateTime and Null value

[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.Nul l; //(also tried =
System.Convert. DBNull;

if (tbxStartDate.T ext!="")
{
dateStartDate = Convert.ToDateT ime(tbxStartDat e.Text);
}
/*Also tried the following with no success.
else
{
dateStartDate = DBNull.Value;
}*/
//Set SQL parameters and populate with form values
sqlCommand1.Par ameters.Add("@S tartDate", SqlDbType.Small DateTime).Value =
dateStartDate;

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

[Matt Jensen]

Got it here thanks
http://www.c-sharpcorner.com/Code/20...orDateTime.asp
Cheers
Matt

"Matt Jensen" <re************ ***@microsoft.c om> wrote in message
news:Oa******** ******@TK2MSFTN GP14.phx.gbl...

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.Nul l; //(also tried =
System.Convert. DBNull;

if (tbxStartDate.T ext!="")
{
dateStartDate = Convert.ToDateT ime(tbxStartDat e.Text);
}
/*Also tried the following with no success.
else
{
dateStartDate = DBNull.Value;
}*/
//Set SQL parameters and populate with form values
sqlCommand1.Par ameters.Add("@S tartDate", SqlDbType.Small DateTime).Value
= dateStartDate;

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