How to save null value to Mysql table DateTime field In C#

Question

I want to save null value for dateTime field if the DateEdit (dev express C# windows application control) editvalue is null.

If dateEdit Control has a edit value it save the selected date.If its is null it save a default date But i want to save Null value if the dateEdit value is null.

SAmple COde: i am using entity frame work,

Orders ord= new Orders();
ord.OrderDate= dateEdit1.DateTime;**//here i want to save null value if the dateEdit control value is null** 
Objcontext.Orders.AddObject(ord);
Objcontext.SaveChanges();

Need more information ... how are you writing the values to the table? Post some sample code, please. — phoog
– phoog, Commented Sep 7, 2012 at 6:32
Thank you for replying me, pls tell me how to save null value to the date field — Vinoth
– Vinoth, Commented Sep 7, 2012 at 6:40
The OrderDate property of the Orders class should be nullable -- it should have the type DateTime? or Nullable<DateTime> (this is two different ways of writing the same thing). I don't know Entity Framework well enough to advise you on how to achieve that. Once you have achieved that, set the property with the null keyword, like this: ord.OrderDate = null; — phoog
– phoog, Commented Sep 7, 2012 at 6:52

John Woo · Accepted Answer · 2012-09-07 09:25:43Z

2

are you using ADO Command with Parameters? if so then try something this,

// other codes here
command.AddWithValue("@paramName",  (dateEdit.EditValue == null) ? DBNull.Value : dateEdit.EditValue);

dateEdit Control is a DevExpress component right?

or try

Orders ord = new Orders();
ord.OrderDate = (dateEdit1.DateTime == null ? DBNull.Value : dateEdit1.DateTime); //here i want to save null value if the dateEdit control value is null 
Objcontext.Orders.AddObject(ord);
Objcontext.SaveChanges();

enter image description here

edited Sep 7, 2012 at 9:25

answered Sep 7, 2012 at 6:33

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

Comments

Prasath Albert · Accepted Answer · 2012-09-07 06:38:16Z

0

You should set the Field property as NULL for accepting NULL values. Otherwise it will save like "0000-00-00".

answered Sep 7, 2012 at 6:38

Prasath Albert

1,45710 silver badges20 bronze badges

1 Comment

Vinoth Over a year ago

that field has that property .

aiodintsov · Accepted Answer · 2012-09-07 06:40:09Z

0

use Nullable type:

DateTime ? nullableDate = GetSomeDate();

this also applies to other value types.

There is also DBNull class that may be helpful in such operations. Use could be like this:

sqlCommand.Parameters.AddWithValue("created",nullableDate??DBNull.Value);

or similar. starting with .NET Framework 4 MS wants us to pass DBNull.Value for null values.

answered Sep 7, 2012 at 6:40

aiodintsov

2,61517 silver badges17 bronze badges

3 Comments

Vinoth Over a year ago

i am using entity framework pls tell me how to save null value to date field

aiodintsov Over a year ago

EF will create nullable types for nullable columns if you do everything right

Vinoth Over a year ago

Thank you aiodintsov Now i saves the null value for the empty dateEdit

vishnu saini · Accepted Answer · 2012-09-07 06:55:26Z

0

It may help to store null DateTime for your DateEdit.

DateTime? DateEdit = null;

answered Sep 7, 2012 at 6:55

vishnu saini

661 silver badge11 bronze badges

Comments

enb081 · Accepted Answer · 2013-03-28 09:16:47Z

0

Orders ord = new Orders();

if(dateEdit1.EditValue!=null)

{ord.OrderDate = dateEdit1.DateTime.Date}

else

{ord.OrderDate= null}

dateEdit control value is null 
Objcontext.Orders.AddObject(ord);
Objcontext.SaveChanges();

Now, I am able to save null value for empty DateTime in the DateEdit.

edited Mar 28, 2013 at 9:16

enb081

4,09912 gold badges45 silver badges66 bronze badges

answered Sep 7, 2012 at 7:22

Vinoth

7733 gold badges12 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to save null value to Mysql table DateTime field In C#

5 Answers 5

Comments

1 Comment

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related