How to set DateTime to DBNull

Question

I am trying to set the database`s column for the DateTime to null (if user does not select the date from dateTimePicker tool.

This I got:

if(someDate == DateTime.MinValue) { // or "== null" for Nullable<DateTime>
    dateParam.Value = DBNull.Value;
} else {
    dateParm.Value = someDate;
}

and this is my code:

What am I doing wrong?

Answer 1

You have to add the parameter first.

cmd1.Parameters.Add("@DatumNastanka", SqlDbType.DateTime);

then you can assign the value:

cmd1.Parameters["@DatumNastanka"].Value = null;

(No need to use DBNull when passing to the database.  DBNull is only something that comes out of the database.  :)

---

Coding Light - Illuminated Ideas and Algorithms in Software
Coding Light Wiki • LinkedIn • ForumsBrowser

Answer 2

Answer 3

You forgot your "@". 

DatumNastanka isn't in the collection, but @DatumNastanka is. 

---

Coding Light - Illuminated Ideas and Algorithms in Software
Coding Light Wiki • LinkedIn • ForumsBrowser

Answer 4

hehe, I saw it right before your post :)

And my version works too :)

 thx