Setup default value if is datetimepicker in sql column null

Goran Bibic

8y1.4kLearn iOS Programming

Exp

vrijemeodjaveDateTimePicker.Value = Convert.ToDateTime(string.IsNullOrWhiteSpace(vrijemeodjaveDateTimePicker.Text) ? emptydate : prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn3"].Value);

Default value

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

38 Replies

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

Amit Gupta8y ago
Accepted answer
That's what I had posted, understand the snippet carefully.

Let me express this in another way
....
radnikComboBox.Text = radnik;
               //vrijemeprijaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// don't convert it to datetime (as you said, it may be null)
var stringValue = (prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// not checking stringValue is null or not
var dateValue = string.IsNullOrEmpty(stringValue)?DateTime.MinValue:Convert.ToDateTime("2018-01-01 00:00:00");
// now, datevalue is the new value for datepicker
vrijemeodjaveDateTimePicker.Value = dateValue;
Goran Bibic8y ago
Please help me to solve the problem
vrijemeodjaveDateTimePicker.Value = DBNull.Value.Equals("2018-01-01 00:00:00") ? emptydate : vrijemeodjaveDateTimePicker.Value;
I need value from datagrid show in datetimepicker, if is null show 2018-01-01 00:00:00
What to do?
Goran Bibic8y ago
Some easy solution?
Amit Gupta8y ago
Before looking and do repair of the code, one should have some basic knowledge of fundamentals of coding, what you are going to do, what output should be generated. The code which I gave you yesterday is what you have expected. You just need to remove the min and max date property. Don't mix other's code that cause more confusing scenario.
Goran Bibic8y ago
I am looking on the internet and create cod...but need to repair him

I need that simple code...if hvae value in cell to show in datetimepicker if is value null to show 2018-01-01 00:00:00

Why is complicate?
Amit Gupta8y ago
Is this code developed by you or you have downloaded from somewhere. Its a basic property that you can find by selecting the datetimepicker and look at the property window.
Goran Bibic8y ago
Is this solution
vrijemeodjaveDateTimePicker.Value = DBNull.Value.Equals("2018-01-01 00:00:00") ? emptydate : vrijemeodjaveDateTimePicker.Value;
Have one problem...when datagrid column have value in datetimepicker he show me 2018-01-01 00:00:00.

I need to show value from cell in datetimepicker if have, is is null to show 2018-01-01 00:00:00
Goran Bibic8y ago
No, how t do that?

Don't you removed the property of mindate and max date in property window?
Amit Gupta8y ago
Don't you removed the property of mindate and max date in property window?
Goran Bibic8y ago
No, I am not solve the problem...
Amit Gupta8y ago
Did you got your issue resolved?
Goran Bibic8y ago
How to do this?

You had applied the property (MinDate and MaxDate) in datetimepicker property, remove them to resolve this issue
Amit Gupta8y ago
You had applied the property (MinDate and MaxDate) in datetimepicker property, remove them to resolve this issue
Goran Bibic8y ago
This is error
Activated Event Time Duration Thread
Exception thrown: 'System.ArgumentOutOfRangeException' in System.Windows.Forms.dll ("Value of '1.1.0001. 00:00:00' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.") 14.33s [17640]
Amit Gupta8y ago
Please be specific to what you are asking for. Don't get confused while asking your doubts, be prepared and relax.

Here's the code
....
radnikComboBox.Text = radnik;
               //vrijemeprijaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// don't convert it to datetime (as you said, it may be null)
var stringValue = (prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// now, datevalue is the new value for datepicker
vrijemeodjaveDateTimePicker.Value =  string.IsNullOrEmpty(Convert.ToString(stringValue))? Convert.ToDateTime("2018-01-01 00:00:00"  : Convert.ToDateTime(stringValue)
Goran Bibic8y ago
I find error
Activated Event Time Duration Thread
Exception thrown: 'System.ArgumentOutOfRangeException' in System.Windows.Forms.dll ("Value of '1.1.0001. 00:00:00' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.") 14.33s [17640]
Goran Bibic8y ago
This solution not work...another? Before this work...now not...
....
radnikComboBox.Text = radnik;
               //vrijemeprijaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// don't convert it to datetime (as you said, it may be null)
var stringValue = (prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// now, datevalue is the new value for datepicker
if(string.IsNullOrEmpty(Convert.ToString(stringValue)))
vrijemeodjaveDateTimePicker.Value = dateValue;
Amit Gupta8y ago
God !!

Try this
....
radnikComboBox.Text = radnik;
               //vrijemeprijaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// don't convert it to datetime (as you said, it may be null)
var stringValue = (prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// now, datevalue is the new value for datepicker
if(string.IsNullOrEmpty(Convert.ToString(stringValue)))
vrijemeodjaveDateTimePicker.Value = dateValue;
Goran Bibic8y ago
Yes thats it!!!! Bravo

You want like

if(sqlcolumndate = null)

datepicker.value = "2018-01-01 00:00:00"

else

datepicker.value = sqlcolumndate

Is it like that? or something else. If yes, then I believe that you can apply this logic

Where to put this code?
var stringValue = (prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);



               // not checking stringValue is null or not

               var dateValue = string.IsNullOrEmpty(Convert.ToString(stringValue)) ? DateTime.MinValue : Convert.ToDateTime("2018-01-01 00:00:00");



               // now, datevalue is the new value for datepicker

               vrijemeodjaveDateTimePicker.Value = dateValue;
Amit Gupta8y ago
You want like
if(sqlcolumndate = null)
datepicker.value = "2018-01-01 00:00:00"
else
datepicker.value = sqlcolumndate

Is it like that? or something else. If yes, then I believe that you can apply this logic
Goran Bibic8y ago
I try now...work app...after clean...app work but in datetimepicker is value always 2018-01-01 00:00:00 ? Why? I need that value only if is column value null
Goran Bibic8y ago
I try now...work app...after clean...app work but in datetimepicker is value always 2018-01-01 00:00:00 ? Why? I need that value only if is column value null
Amit Gupta8y ago
App not start?

What does it mean? What error you are getting, show that error.

I suggest you to clean and rebuild the project and then try, sometimes that works too..
Goran Bibic8y ago
Complete column have value 2018-01-01 00:00:00...that value need only if is column null
Goran Bibic8y ago
I try now...app work but in datetimepicker is value always 2018-01-01 00:00:00
Amit Gupta8y ago
app no ??

where's the app no, you haven't posted the code that contains app no.
Goran Bibic8y ago
No...that is not solution....app no start if have null value in column...when delete that column...code working fine...what is error?

Now when column value is null app not start, if I delete that row, app work, but datetimepicker is always 2018-01-01 00:00:00
Amit Gupta8y ago
It was just asking that we got value in object and we coded for string.
Here's the updated snippet
....
radnikComboBox.Text = radnik;
               //vrijemeprijaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// don't convert it to datetime (as you said, it may be null)
var stringValue = (prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);

// not checking stringValue is null or not
var dateValue = string.IsNullOrEmpty(Convert.ToString(stringValue))?DateTime.MinValue:Convert.ToDateTime("2018-01-01 00:00:00");

// now, datevalue is the new value for datepicker
vrijemeodjaveDateTimePicker.Value = dateValue;
Goran Bibic8y ago
This is a possible solution but have one error

Severity Code Description Project File Line Suppression State
Error CS1503 Argument 1: cannot convert from 'object' to 'string' prijava_radnika

line 10 on your code
....
radnikComboBox.Text = radnik;
               //vrijemeprijaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// don't convert it to datetime (as you said, it may be null)
var stringValue = (prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
// not checking stringValue is null or not
var dateValue = string.IsNullOrEmpty(stringValue)?DateTime.MinValue:Convert.ToDateTime("2018-01-01 00:00:00");
// now, datevalue is the new value for datepicker
vrijemeodjaveDateTimePicker.Value = dateValue;
Goran Bibic8y ago
I not need conectiomn etc...
var query = "select dateColumn from tablename;
var value = cmd.ExecuteScalar();

//Assuming somehow above has been achieved

var DValue = value== DbNull.Value?DateTime.MinValue : Convert.ToDateTime(value);

vrijemeodjaveDateTimePicker.Value = DValue;
vrijemeodjaveDateTimePicker.Value = vrijemeodjaveDateTimePicker.Value == System.DateTime.MinValue ? DateTime.Parse("2018-01-01 00:00:00") : vrijemeodjaveDateTimePicker.Value;
I just need line 9...if is column value null to put in datetimepicker value 2018-01-01 00:00:00
and in datagrid empty cell
Amit Gupta8y ago
Damm !! You haven't expressed your condition
var query = "select dateColumn from tablename;
var value = cmd.ExecuteScalar();

//Assuming somehow above has been achieved

var DValue = value== DbNull.Value?DateTime.MinValue : Convert.ToDateTime(value);

vrijemeodjaveDateTimePicker.Value = DValue;
vrijemeodjaveDateTimePicker.Value = DValue == System.DateTime.MinValue ? DateTime.Parse("2018-01-01 00:00:00") : DValue;
I had made modification, hope thats what you are looking for
Goran Bibic8y ago
This is my code
Line 17 is problem...
Code working fine...but line 17 is problem...I want to write that line...: IF is sql cell null to show empty value in data greed and 2018-01-01 00:00:00 in datetimepicker
private void prijava_radnikaDataGridView_SelectionChanged(object sender, EventArgs e)
       {

           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();


               redni_brojTextBox.Text = redni_broj;
               idPrijavaTextBox.Text = id;
               radnikComboBox.Text = radnik;
               vrijemeprijaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);
               vrijemeodjaveDateTimePicker.Value = vrijemeodjaveDateTimePicker.Value == System.DateTime.MinValue ? DateTime.Parse("2018-01-01 00:00:00") : vrijemeodjaveDateTimePicker.Value;

           }
       }
Amit Gupta8y ago
Your condition in both the snippet are not identical, can you write your condition in simple algorithm
Goran Bibic8y ago
I hope you understand
Goran Bibic8y ago
I need this condition
private DateTime emptydate = DateTime.Parse("2018-01-01 00:00:00");
Here in selection changed
private void prijava_radnikaDataGridView_SelectionChanged(object sender, EventArgs e)
       {
           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();


               redni_brojTextBox.Text = redni_broj;
               idPrijavaTextBox.Text = id;
               radnikComboBox.Text = radnik;
               vrijemeprijaveDateTimePicker.Value = Convert.ToDateTime(prijava_radnikaDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value);

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

           }
       }
Amit Gupta8y ago
1. var query = "select dateColumn from tablename;
2. var value = cmd.ExecuteScalar();
4. //Assuming somehow above has been achieved
6. var DValue = value== DbNull.Value?DateTime.Now : Convert.ToDateTime(value);
8. // Change the value accordingly
Do let me know if you require any clarification

Goran Bibic8y ago

Yes

Amit Gupta8y ago

Hey!! Are you asking to get the default value in datetimepicker if date value from sql is null?