Hi,
I wrote a program to split the Date and Time as 2 different columns from 1 column.
If i have a blank value in datetime field, the split functionality is not working.
It's giving error stating "FormatException was unhandled" for below mentioned line:
DateTime Time = Convert.ToDateTime(column[i].ToString());
Please let me know where i have to correct.
Total code for that functionality is:
private void btnSplit_Click(object sender, EventArgs e)
{
DataGridViewTextBoxColumn dgvcdate = new DataGridViewTextBoxColumn();
dgvcdate.Name = cmbColumnCombo.Text;
dgvcdate.HeaderText = cmbColumnCombo.Text;
dataGridView1.Columns.Add(dgvcdate);
DataGridViewTextBoxColumn dgvctime = new DataGridViewTextBoxColumn();
dgvctime.Name = txtColumnName.Text.Replace(" ", "");
dgvctime.HeaderText = txtColumnName.Text;
dataGridView1.Columns.Add(dgvctime);
for (int RowCount = 1; RowCount <= strfile.Length - 1; RowCount++)
{
if (strfile[RowCount].ToString() != "")
{
if (RowCount != 0)
{
string[] column = strfile[RowCount].Split('þ');
for (int i = 1; i < column.Length - 1; i++)
{
if (cmbColumnCombo.SelectedIndex == ((i - 1) / 2))
{
if (column[i].ToString() != "\u0014")
{
dataGridView1.Rows.Add();
DateTime Time = Convert.ToDateTime(column[i].ToString());
dataGridView1.Rows[RowCount - 1].Cells[txtColumnName.Text.Replace(" ", "")].Value = Time.ToString("HH:mm:ss");
dataGridView1.Rows[RowCount - 1].Cells[cmbColumnCombo.Text].Value = Time.ToString("dd/MM/yyyy");
//dataGridView1.Rows[RowCount - 1].Cells[cmbColumn1.Text].Value += column[i].ToString();
}
}
}
}
}
}
}