Datetimepicker selection changed

Sign in to answer this question.

• 

  Nitin Sontakke8y agoPosted Mar 24, 2018, 10:57 PM

  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:  

  1. declare @someTable table  
  2. (  
  3.   [someColumn] datetime null  
  4. )  
  5.   
  6. insert into @someTable ([someColumn]) values  
  7.  (getdate())  
  8. ,(null)  
  9.   
  10. select *, isnull([someColumn], '2018-01-01 00:00:00') [nullHandled]  
  11. from @someTable  

   ...and output looks as follows: 

  1. -- output    
  2.     
  3. someColumn              nullHandled    
  4. ----------------------- -----------------------    
  5. 2018-03-25 09:24:25.987 2018-03-25 09:24:25.987    
  6. NULL                    2018-01-01 00:00:00.000    

   
• 

  Rafnas T P8y agoPosted Mar 25, 2018, 6:10 AM

  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;  
• GB

  Goran Bibic8y agoPosted Mar 25, 2018, 2:39 AM

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

  Bryian Tan8y agoPosted Mar 24, 2018, 11:02 PM

  Let assume dummyDate in the example is coming from the database, if it null then use the emptyDate else keep the selected value

   

  1. private DateTime emptydate = DateTime.Parse("2018-01-01 00:00:00");  
  2.       private void vrijemeodjaveDateTimePicker_ValueChanged(object sender, EventArgs e)  
  3.       {  
  4.           var dummyDate = DBNull.Value; //DateTime.Parse("2018-02-01 12:30:00");  
  5.   
  6.           vrijemeodjaveDateTimePicker.Value =  
  7.               DBNull.Value.Equals(dummyDate) ? emptydate : vrijemeodjaveDateTimePicker.Value;  
  8.       }