How to pass the null value to datetime datatype in asp.net?

Question

cmdInsertUpdateConsultantDetails.Parameters.Add("@DateofExpiry", SqlDbType.DateTime);
if (txtdateofexpiry.Text.Trim() == "")
{
    cmdInsertUpdateConsultantDetails.Parameters["@DateofExpiry"].Value =
}
else
{
    cmdInsertUpdateConsultantDetails.Parameters["@DateofExpiry"].Value = 
        Convert.ToDateTime(txtdateofexpiry.Text.Trim());
}

add "?". DateTime ? currentDateTime; – giri77 Nov 24 '11 at 09:57 — giri77, Nov 24 '11 at 09:57

Ufuk Hacıoğulları · Answer 1 · 2011-11-24T09:50:31.050

3

DateTime is a value type, it cannot be null. You can use Nullable<DateTime> (or the syntax shortform DateTime?) instead of that.

Here's an example:

DateTime? dateTime;
DateTime.TryParseExact(txtdateofexpiry.Text.Trim(), "dd/MM/yyyy", null, DateTimeStyles.None, out dateTime);

edited Nov 24 '11 at 09:50

answered Nov 24 '11 at 09:41

Ufuk Hacıoğulları

37,978
12
114
156

datetimeStyle.None is the error any namespaces are added pls give me some idea – hmk Nov 24 '11 at 09:53
DateTimeStyles enum is in System.Globalization namespace if that's what you are asking. You should also check [DateTime formats here](http://www.csharp-examples.net/string-format-datetime/) – Ufuk Hacıoğulları Nov 24 '11 at 10:47

score 3 · Answer 2 · edited May 23 '17 at 10:34

3

DateTime is not a nullable type. If you don't supply a value it's equal to DateTime.MinValue

You can use

DateTime? MyNullableDateTime;

This question has more detail in the answer, if you are interested.

edited May 23 '17 at 10:34

Community

1
1

answered Nov 24 '11 at 09:41

Neil Thompson

6,356
2
30
53

score 2 · Accepted Answer · answered Nov 24 '11 at 10:09

2

Simple here you can give DbNull.Value to pass NULL value.

if (txtdateofexpiry.Text.Trim() == "")
{
    cmdInsertUpdateConsultantDetails.Parameters["@DateofExpiry"].Value = DbNull.Value
}

It's also recommended the use of DateTime? or Nullable

answered Nov 24 '11 at 10:09

Sreekumar P

5,900
11
57
82

score 0 · Answer 4 · answered Nov 24 '11 at 09:44

you can pass it as DBNull.Value. So it would be

cmdInsertUpdateConsultantDetails.Parameters.Add("@DateofExpiry", SqlDbType.DateTime);
if (txtdateofexpiry.Text.Trim() == "")
{
    cmdInsertUpdateConsultantDetails.Parameters["@DateofExpiry"].Value = DBNull.Value;
}
else
{
    cmdInsertUpdateConsultantDetails.Parameters["@DateofExpiry"].Value = 
          Convert.ToDateTime(txtdateofexpiry.Text.Trim());
}

How to pass the null value to datetime datatype in asp.net?

4 Answers4