Setup default value if is datetimepicker in sql column null

Question

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

Amit Gupta · 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;

Amit Gupta · Answer

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

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

No, how t do that? Don't you removed the property of mindate and max date in property window?

Amit Gupta · Answer

Don't you removed the property of mindate and max date in property window?

Goran Bibic · Answer

No, I am not solve the problem...

Amit Gupta · Answer

Did you got your issue resolved?

Goran Bibic · Answer

How to do this? You had applied the property (MinDate and MaxDate) in datetimepicker property, remove them to resolve this issue

Amit Gupta · Answer

You had applied the property (MinDate and MaxDate) in datetimepicker property, remove them to resolve this issue

Goran Bibic · Answer

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

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

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

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

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

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

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

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

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

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

Complete column have value 2018-01-01 00:00:00...that value need only if is column null

Goran Bibic · Answer

I try now...app work but in datetimepicker is value always 2018-01-01 00:00:00

Amit Gupta · Answer

app no ?? where's the app no, you haven't posted the code that contains app no.

Goran Bibic · Answer

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

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

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

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

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

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

Your condition in both the snippet are not identical, can you write your condition in simple algorithm

Goran Bibic · Answer

I hope you understand

Goran Bibic · Answer

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

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

Amit Gupta · Answer

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

Goran Bibic · Answer

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?

Amit Gupta · Answer

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

Yes

Goran Bibic · Answer

Some easy solution?

Goran Bibic · Answer

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?

Setup default value if is datetimepicker in sql column null

Answers (38)