How to send null value If datetime input value is null

Question

0.00/5 (No votes)

See more:

cmd.Parameters.AddWithValue("@review_date",Convert.ToDateTime(review_date));

In this case review_date is null Exception will be occurs

Below This Query not working

cmd.Parameters.AddWithValue("@review_date", string.IsNullOrEmpty(review_date) ? (DateTime?)null or DateTime.MinValue or DBNULL.Value: Convert.ToDateTime(review_date));

DBNULL.Value:no conversion between System.datetime and system.DBNull Exception occurs
DateTime.MinValue: stack overflow Exception occurs

But Below This type use Query its working

string mindate="01/01/1990";
cmd.Parameters.AddWithValue("@review_date", string.IsNullOrEmpty(review_date) ? Convert.ToDateTime(mindate) : Convert.ToDateTime(review_date));

Posted 23-Feb-15 22:16pm

Member 11340148

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2015-02-25T04:40:00

The (DateTime?)null option is close - the code will compile, but the parameter won't be passed to the query. If the parameter had a default value of Null, the code would work; otherwise, you'll get a missing parameter error.

In order to pass Null as the parameter value, you have to use DBNull.Value. However, if your ternary expression has return values of DBNull and DateTime, the compiler won't be able to determine the return type of the expression.

The trick is to force the return type to be object, by explicitly boxing the DateTime value. (The overhead of boxing the value is irrelevant, since it's being passed to a method parameter of type object, so it would need to be boxed anyway.)

This should work:

C#

cmd.Parameters.AddWithValue("@review_date", string.IsNullOrEmpty(review_date) ? DBNull.Value : (object)Convert.ToDateTime(review_date));

Naveen Kumar Tiwari · Answer 2 · 2015-02-23T22:23:00

Solution 1

check following condition........Hope this helps
if(review_date!=null)
{
cmd.Parameters.AddWithValue("@review_date",Convert.ToDateTime(review_date));
}
else
{
//Whatever you want to send
}

Posted 23-Feb-15 22:23pm

Naveen Kumar Tiwari

Updated 23-Feb-15 22:26pm

v2

manchanx · Answer 3 · 2015-02-23T22:26:00

Solution 2

This should do it:

cmd.Parameters.AddWithValue("@review_date", 
  String.IsNullOrEmpty(review_date) ? DBNull.Value : Convert.ToDateTime(review_date));

Posted 23-Feb-15 22:26pm

manchanx

Samatha Reddy G · Answer 4 · 2015-02-25T03:47:00

Solution 3

try this

cmd.Parameters.AddWithValue("@review_date",Convert.ToDateTime(review_date == null?DateTime.MinValue:review_date));

Posted 25-Feb-15 3:47am

Samatha Reddy G