How to compare Date values in DataGrid with Current date?

Dawood Abbas

I have tried with
protected void gridCustomer_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DateTime olddate = Convert.ToDateTime(e.Row.Cells[9].Text); /*Error : String was not recognized as a valid DateTime.*/
DateTime today = DateTime.Now;

if (olddate > today)

{

Label status = (Label) e.Row.FindControl("lblStatus");

status.Text = "AutoHold";

}

}
}

6 Replies

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

Dawood Abbas11y ago
DateTime olddate;
DateTime.TryParseExact(e.Row.Cells[9].Text, "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out olddate);

I used above code then in old date getting '1/1/0001' where as in my grid cell i have '4/1/2015'
Dawood Abbas11y ago
showing content not found.
Dawood Abbas11y ago
but in old date getting '1/1/0001' where as in my grid cell i have '4/1/2015' by above your mentioned code.

Azaad Abbas11y ago

DateTime olddate;
DateTime.TryParseExact(e.Row.Cells[9].Text, "yyyy-MM-dd",CultureInfo.InvariantCulture,DateTimeStyles.None, out olddate)

Saber Shaikh11y ago
first check e.Row.Cells[9].Text is null or blank
if is blank the false you error other wise out put proper so only Check if condition before
DateTime olddate = Convert.ToDateTime(e.Row.Cells[9].Text); /*Error : String was not

Blog : http://aspnettutorialscode.blogspot.in/
Akhil Garg11y ago
Your string is not in proper format. https://msdn.microsoft.com/en-us/library/cc165448.aspx Or you can try DateTime.Parse.