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
– giri77

2011-11-24 09:57:34 +00:00
Commented Nov 24, 2011 at 9:57 — giri77
– giri77, Commented Nov 24, 2011 at 9:57

Community · Accepted Answer · 2017-05-23 10:34:23Z

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, 2017 at 10:34

CommunityBot

11 silver badge

answered Nov 24, 2011 at 9:41

Neil Thompson

6,4652 gold badges33 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ufuk Hacıoğulları · Accepted Answer · 2011-11-24 09:50:31Z

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, 2011 at 9:50

answered Nov 24, 2011 at 9:41

Ufuk Hacıoğulları

38.6k14 gold badges120 silver badges157 bronze badges

2 Comments

hmk Over a year ago

datetimeStyle.None is the error any namespaces are added pls give me some idea

Ufuk Hacıoğulları Over a year ago

DateTimeStyles enum is in System.Globalization namespace if that's what you are asking. You should also check DateTime formats here

Sreekumar P · Accepted Answer · 2011-11-24 10:09:50Z

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, 2011 at 10:09

Sreekumar P

6,06812 gold badges62 silver badges84 bronze badges

Comments

Junaid · Accepted Answer · 2011-11-24 09:44:35Z

0

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());
}

answered Nov 24, 2011 at 9:44

Junaid

1,75517 silver badges26 bronze badges

Collectives™ on Stack Overflow

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

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related