Datetimepicker selection changed

Question

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

Nitin Sontakke · 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 P · Answer

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 Bibic · Answer

This is not solution...app not startt if have some empty value....

Bryian Tan · Answer

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; }

Datetimepicker selection changed

Answers (4)