CODEWITHSUNDEEP
c#sql-serverdatetimenullabledbcommand
DortGen
DortGen

Reputation: 412

How to Convert a Nullable DateTime variable's null value to DbNull.Value

I have a nullable DateTime Variable. And I want to write it to SQL DB. When i try to insert:

If the variable has value there is no problem.

But if it hasn't a value, insertion interrupting with an error.

I want to ask: How can we insert nullable DateTime to Sql via DbCommand Parameter?

(P.S. : Sql column is nullable too.)

DateTime? myDate = null;
DbCommand dbCommand = new DbCommand();
dbCommand.Parameters.Add("NullableSqlDateField", DbType.DateTime, myDate);

Upvotes: 3

Views: 6870

Answers (2)

Brijesh Mishra
Brijesh Mishra

Reputation: 2748

try this 

if(myDate.HasValue)
  dbCommand.Parameters.Add("NullableSqlDateField", DbType.DateTime, myDate.Value);
else
  dbCommand.Parameters.Add("NullableSqlDateField", DbType.DateTime, DbNull.Value);

Upvotes: 0

matt
matt

Reputation: 9412

Try the null coalescing operator:

dbCommand.Parameters.Add("NullableSqlDateField", DbType.DateTime, (object) myDate ?? DbNull.Value);

Upvotes: 13

Related Questions