string was not recognized as a valid dateTime.

Emmmanuel FIADUFE

5y1.3kVisual Basic .NET

am using dateTimePicker in dataGridView and SQL database

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
string ColName = dataGridView1.Columns[e.ColumnIndex].Name;
if (ColName == "ColEdit")
{
formExecutiveInfoEntry frm = new frmExecutiveInfoEntry(this);
form.dtDateJoin.Text = dataGridView1.Columns[1].DefaultCellStyle.Format = "dd-MM-yyyy";
}
}
}

13 Replies

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

Amit Gupta5y ago
Accepted answer
Please use debugging process and share the extract code snippet where the exception occurs.
+3
Emmmanuel FIADUFE5y ago
Hello team thanks for your support, i have been able to correct the errorThis is what work for me frm.dtDateJoin.CustomFormat = datagridView1.Rows[e.RowIndex].Cells[1].Value.ToString()
+2
Amit Gupta5y ago
Ah! It should be
frm.dtDateJoin.Value = Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString());

It should work definitely, if its not then please zip your project and share with us with sample data that causes the exception, so we can do the needful correction and revert you with the solution
+3
Emmmanuel FIADUFE5y ago
Hello team, please any assistance, how can I rewrite this code. frm.dtDateJoin.SelectedDate = Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString());
+3
Emmmanuel FIADUFE5y ago
Yes I tried this but it didn'nt work frm.dtDateJoin.SelectedDate = Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString());
+3
Amit Gupta5y ago
Can you share the value of both the dates (join and dob), it might be blank or might have the wrong dd-MM-yyyy format.
+3
Amit Gupta5y ago
Have you tried frm.dtDateJoin.SelectedDate = Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString());
+3
Emmmanuel FIADUFE5y ago
Hello team, please after the changes the same error still exist
+3
Sharma Raushan5y ago
You can't use text for datepicker it has selecteddate property also convert the string to date using Convert.ToDateTime() or other conversion operators.
+3
Amit Gupta5y ago
Hey

Your date field seems a datepicker? right? then please consider using its SelectedDate properties instead of Text.

Change the below line
cm.Parameters.AddWithValue("@Joindate", dtDateJoin.Text);
cm.Parameters.AddWithValue("@DOB", dtBirthdate.Text);
With
cm.Parameters.AddWithValue("@Joindate", dtDateJoin.SelectedDate);
cm.Parameters.AddWithValue("@DOB", dtBirthdate.SelectedDate);
Do try and let us know
+3
Emmmanuel FIADUFE5y ago
@Jignesh Kumar and Hiesh Kidecha, Please your suggestion couldn't resolve the issue, please let me post the entire code here so that you can assist in that regard
+3
Jignesh Kumar5y ago
Hi,

You need to remove assign to textbox, just set formate for column,
if (ColName == "ColEdit")
{
  formExecutiveInfoEntry frm = new frmExecutiveInfoEntry(this);

  dataGridView1.Columns[1].DefaultCellStyle.Format = "dd-MM-yyyy";

}
+3
Hiesh Kidecha5y ago
Add Dataformatstring="dd-MM-yyyy" in bound field column.
+3