Datetimepicker selection changed

Goran Bibic

8y1kLearn iOS Programming

Use this...if is column null i want to show this value in selection changed

private DateTime emptydate = DateTime.Parse("2018-01-01 00:00:00");

How to setup this line for selection changed

vrijemeodjaveDateTimePicker.Value = string.IsNullOrEmpty(vrijemeodjaveDateTimePicker.Value == emptydate) ? ((object)DBNull.Value : vrijemeodjaveDateTimePicker.Value;

If is value in sql is null to show this value 01-01-2018 00:00:00

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Accepted answer
Instead of doing all this gymnastic on C#, often it is a good idea to fix your select statement itself.

So in your select statement itself use syntax like isnull(columnname, '2018-01-01 00:00:00'). Let me show you how to do it as an example:
declare @someTable table
(
  [someColumn] datetime null
)

insert into @someTable ([someColumn]) values
(getdate())
,(null)

select *, isnull([someColumn], '2018-01-01 00:00:00') [nullHandled]
from @someTable
...and output looks as follows:
-- output

someColumn              nullHandled
----------------------- -----------------------
2018-03-25 09:24:25.987 2018-03-25 09:24:25.987
NULL                    2018-01-01 00:00:00.000
Rafnas T P8y ago
hi,
in datetimepicker selection change event you can write folling code

vrijemeodjaveDateTimePicker.Value = vrijemeodjaveDateTimePicker.Value == emptydate? (object)DBNull.Value : vrijemeodjaveDateTimePicker.Value;

or

vrijemeodjaveDateTimePicker.Value = vrijemeodjaveDateTimePicker.Value == emptydate? DBNull.Value : vrijemeodjaveDateTimePicker.Value;
Goran Bibic8y ago
This is not solution...app not startt if have some empty value....
Bryian Tan8y ago
Let assume dummyDate in the example is coming from the database, if it null then use the emptyDate else keep the selected value
private DateTime emptydate = DateTime.Parse("2018-01-01 00:00:00");
      private void vrijemeodjaveDateTimePicker_ValueChanged(object sender, EventArgs e)
      {
          var dummyDate = DBNull.Value; //DateTime.Parse("2018-02-01 12:30:00");

          vrijemeodjaveDateTimePicker.Value =
              DBNull.Value.Equals(dummyDate) ? emptydate : vrijemeodjaveDateTimePicker.Value;
      }