ASP.Net GridView RowDataBound Error: String was not recognized as a valid DateTime

Hi akhter,

You need to check IsNullOrEmpty condition to avoid the error.

if (e.Row.RowType == DataControlRowType.DataRow)
{
    TextBox txtEntryDate = e.Row.FindControl("txtEntryDate") as TextBox;
    TextBox txtEndDate = e.Row.FindControl("txtEndDate") as TextBox;
    if (!string.IsNullOrEmpty(txtEntryDate.Text) && !string.IsNullOrEmpty(txtEndDate.Text))
    {
        DateTime startDate = Convert.ToDateTime(txtEntryDate.Text);
        DateTime endDate = Convert.ToDateTime(txtEndDate.Text);
        TextBox txtHours = e.Row.FindControl("txtHours") as TextBox;
        TextBox txtDays = e.Row.FindControl("txtDays") as TextBox;
        txtHours.Text = endDate.Subtract(startDate).Hours.ToString();
        txtDays.Text = endDate.Subtract(startDate).Days.ToString();
    }
}

Hi akhter,

Same way you can check with IsNullOrEmpty condition in TimeSpan to avoid the error.

protected void TimeSpan(object sender, EventArgs e)
{
    GridViewRow row = (sender as TextBox).NamingContainer as GridViewRow;
    string txtINTIME = (row.FindControl("txtINTIME ") as TextBox).Text;
    string txtTime = (row.FindControl("txtTime") as TextBox).Text;
    if (!string.IsNullOrEmpty(txtINTIME) && !string.IsNullOrEmpty(txtTime))
    {
        TimeSpan timeSpan = Convert.ToDateTime(txtTime) - Convert.ToDateTime(txtINTIME);
    }
}