Setup default value if is datetimepicker in SQL column null

Question

0.00/5 (No votes)

See more:

Setup default value if is datetimepicker in sql column null

Exp

What I have tried:

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

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

Posted 24-Mar-18 5:38am

Goran Bibic

Updated 24-Mar-18 18:28pm

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bryian Tan · Accepted Answer · 2018-03-24T18:30:00

Based on what described in the original post, assuming dummyDate is the value from the database table column. You can modify the code to check if the column is null, if yes, use the emptyDate else keep the selected date from the DateTimePicker control.

C#

var dummyDate = DBNull.Value; //DateTime.Parse("2018-02-01 12:30:00");  
  
  vrijemeodjaveDateTimePicker.Value =  
      DBNull.Value.Equals(dummyDate) ? emptydate : vrijemeodjaveDateTimePicker.Value;

Or maybe you meant to ask, how to set the DateTimePicker to a default value if the column value is NULL , else use the value from the database column.

C#

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

GuyThiebaut · Accepted Answer · 2018-03-24T06:31:00

Solution 1

This will set vrijemeodjaveDateTimePicker.Value to DateTime.Parse("2018-01-01 00:00:00") if vrijemeodjaveDateTimePicker.Value is null:

vrijemeodjaveDateTimePicker.Value ?? DateTime.Parse("2018-01-01 00:00:00");

Posted 24-Mar-18 6:31am

GuyThiebaut

Updated 24-Mar-18 6:32am

v2

Comments

Goran Bibic 24-Mar-18 12:59pm

vrijemeodjaveDateTimePicker.Value = vrijemeodjaveDateTimePicker.Value ?? DateTime.Parse("2018-01-01 00:00:00");

error is

Severity Code Description Project File Line Suppression State
Error CS0019 Operator '??' cannot be applied to operands of type 'DateTime' and 'DateTime' prijava_radnika C:\Users\Bibic Goran\Documents\Visual Studio 2015\Projects\prijava_radnika\prijava_radnika\Form1.cs 562 Active

GuyThiebaut 24-Mar-18 13:05pm

In which case you were incorrect when you stated in your question that the value could be null.

You might want to try this instead:

vrijemeodjaveDateTimePicker.Value = vrijemeodjaveDateTimePicker.Value == System.DateTime.MinValue ? DateTime.Parse("2018-01-01 00:00:00") : vrijemeodjaveDateTimePicker.Value;

Goran Bibic 24-Mar-18 13:16pm

I try this...but it is not default value...selection changed using first value in datagrid

vrijemeodjaveDateTimePicker.Value = vrijemeodjaveDateTimePicker.Value == System.DateTime.MinValue ? DateTime.Parse("2018-01-01 00:00:00") : vrijemeodjaveDateTimePicker.Value;

GuyThiebaut 24-Mar-18 13:20pm

I don't understand what you mean.

Please provide a longer question with:
(1)What you tried.
(2)What you expected the result to be.
(3)What the actual result was.
(4)Why the actual result is incorrect.

Goran Bibic 24-Mar-18 13:22pm

Get the default value in datetimepicker if date value from sql is null...that I want...

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

GuyThiebaut 24-Mar-18 13:29pm

"Get the default value in datetimepicker if date value from sql is null...that I want..."

Still not enough information.
How are you getting the value from sql?
What is the "default value" you speak of?

You really need to learn how to ask questions because I cannot see what is on you screen nor can I read your mind.

In stead of asking for the problem to be solved, try to break the problem into smaller pieces and first google solutions to those smaller pieces then if you don't find answers on google come back to this form to ask specific questions, not general questions.

Goran Bibic 24-Mar-18 13:37pm

Ok...look this...

I have complete solution...for workers work time...when workers come in company in sql have name, surname and datetime when they come...datetime when finish with work is empty...right? ... When I open app...selection change datagreed not working...if have some value from sql empty in column datetime when finish job...I need when is column null to show me defaultvalue i datetime picker...Understand? Default value will be 2018-01-01 00:00:00....In datagreed need to be null when is default value

Goran Bibic 24-Mar-18 13:42pm

private void prijava_radnikaDataGridView_SelectionChanged(object sender, EventArgs e)
{
// if (prijava_radnikaDataGridView.SelectedRows.Count > 0 )
//if (prijava_radnikaDataGridView.SelectedRows.Count > 0 && vrijemeodjaveDateTimePicker == null)
if (prijava_radnikaDataGridView.SelectedRows.Count > 0 )

{

string id = prijava_radnikaDataGridView.CurrentRow.Cells["dataGridViewTextBoxColumn1"].FormattedValue.ToString();
string radnik = prijava_radnikaDataGridView.CurrentRow.Cells["dataGridViewTextBoxColumn9"].FormattedValue.ToString();
string redni_broj = prijava_radnikaDataGridView.CurrentRow.Cells["redni_broj"].FormattedValue.ToString();
// string vrijemeodjave = prijava_radnikaDataGridView.CurrentRow.Cells["dataGridViewTextBoxColumn3"].FormattedValue.ToString();
// DateTime defaultDate = DateTime.Now("").Date;
// string selectedfield = prijava_radnikaDataGridView.CurrentRow.Cells["dataGridViewTextBoxColumn3"].Value.ToString();

redni_brojTextBox.Text = redni_broj;
idPrijavaTextBox.Text = id;
radnikComboBox.Text = radnik;
vrijemeprijaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// vrijemeodjaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn3"].Value);
// vrijemeodjaveDateTimePicker.Value = string.IsNullOrEmpty(vrijemeodjaveDateTimePicker.Value == emptydate) ? ((object)DBNull.Value : vrijemeodjaveDateTimePicker.Value;
// vrijemeodjaveDateTimePicker.Value = (vrijemeodjaveDateTimePicker.Value == emptydate) ? (object)DBNull.Value : vrijemeodjaveDateTimePicker.Value;
// vrijemeodjaveDateTimePicker.Value = Convert.ToDateTime(string.IsNullOrWhiteSpace(vrijemeodjaveDateTimePicker.Text) ? emptydate : prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn3"].Value);
// comm.Parameters.Add("?VrijemeOdjave", MySqlDbType.DateTime).Value = (odjavaProizDatePicker.Value == emptyDate) ? (object)DBNull.Value : odjavaProizDatePicker.Value;
//string.IsNullOrWhiteSpace(dateTimePickerToClear.Text)? null(DateTime?)dateTimePickerToClear.Value;

// vrijemeodjaveDateTimePicker.Value = Convert.ToDateTime(selectedfield);
// DateTime selectedDateTime = (vrijemeodjave == null) ? emptydate : Convert.ToDateTime("2018-01-01 00:00:00");

vrijemeodjaveDateTimePicker.Value = vrijemeodjaveDateTimePicker.Value == System.DateTime.MinValue ? DateTime.Parse("2018-01-01 00:00:00") : vrijemeodjaveDateTimePicker.Value;

}
}

Goran Bibic 24-Mar-18 13:08pm

Severity Code Description Project File Line Suppression State
Error CS1525 Invalid expression term ';' prijava_radnika C:\Users\Bibic Goran\Documents\Visual Studio 2015\Projects\prijava_radnika\prijava_radnika\Form1.cs 572 Active
Error CS1003 Syntax error, ':' expected prijava_radnika C:\Users\Bibic Goran\Documents\Visual Studio 2015\Projects\prijava_radnika\prijava_radnika\Form1.cs 572 Active
Error CS1002 ; expected prijava_radnika C:\Users\Bibic Goran\Documents\Visual Studio 2015\Projects\prijava_radnika\prijava_radnika\Form1.cs 572 Active
Error CS1513 } expected prijava_radnika C:\Users\Bibic Goran\Documents\Visual Studio 2015\Projects\prijava_radnika\prijava_radnika\Form1.cs 572 Active
Error CS0201 Only assignment, call, increment, decrement, and new object expressions can be used as a statement prijava_radnika C:\Users\Bibic Goran\Documents\Visual Studio 2015\Projects\prijava_radnika\prijava_radnika\Form1.cs 572 Active

GuyThiebaut 24-Mar-18 13:11pm

I originally pasted a typo - try what is in the comment above, also try to understand what it is doing.
Have a read up on what a ternary is.

Setup default value if is datetimepicker in SQL column null

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Setup default value if is datetimepicker in SQL column null

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us