Null DateTime Insert into SQL by Asp.Net [duplicate]

Question

I want to insert a date or a null value into a date time field(SQL).

But I cannot insert the null value.

I want to do this without SP.

you set the DBNull msdn.microsoft.com/en-us/library/system.dbnull(v=vs.110).aspx — Aristos
– Aristos, Commented Feb 10, 2014 at 6:53
Are you writing SQL (structured query language) and really mean Microsoft SQL Server (the actual product) by this? If yes: please add sql-server tag to make this clear. If not: what database system is this for? — marc_s
– marc_s, Commented Feb 10, 2014 at 6:59

angfreak · Accepted Answer · 2014-02-10 07:33:59Z

1

cmd1.Parameters["@DateTimeParamName"].Value = getDate ?? DBNull.Value;

answered Feb 10, 2014 at 7:33

angfreak

1,0032 gold badges12 silver badges27 bronze badges

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

Comments

Damith · Accepted Answer · 2014-02-10 06:55:10Z

0

you need to set DBNull.Value if you using parameters

cmd.Parameters["@DateTimeParamName"].Value = DBNull.Value

answered Feb 10, 2014 at 6:55

Damith

63.2k13 gold badges106 silver badges154 bronze badges