datagrid cell color change based on datetime

rulec444

22y4.5k.NET

I have a bound datagrid on an asp.net page. One column is filled with a DateDue, datetime. I am trying to check and if the date is less than a week out, I need to make the cell or text Red. This is what I've attempted and, of course, it doesn't work: private void dgProjects_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView drv = (DataRowView)e.Item.DataItem; if(drv.Row.ItemArray[6] <= DateTime.Now )//and somehow add 7 days to this date) { e.Item.Cells[3].BackColor = Color.Red; } } } Thanks - I appreciate any help!!

6 Replies

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

rulec44422y ago
Sure - this is what I did: private void dgExtractList_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { DateTime notifyDue = DateTime.Now.AddDays(7); if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView drv = (DataRowView)e.Item.DataItem; string strDateDue = (drv.Row.ItemArray[2]).ToString(); if(strDateDue != "") { DateTime dateDue = DateTime.Parse(strDateDue); TimeSpan lessThan7 = notifyDue.Subtract(dateDue); int less = (lessThan7.Days); TimeSpan pastDue = dateDue.Subtract(notifyDue); int past = (pastDue.Days); if((less <= 7) && (less > -1)) { e.Item.Cells[3].BackColor = Color.YellowGreen; } if(past < -7) { e.Item.Cells[3].BackColor = Color.Red; } } } } May not be real pretty - but it works!! Thanks again.
fadil197722y ago
Hi !! did you solveb it. I am interseted to know the solution and the code will be useful if you do not mind to attach it.
rulec44422y ago
Thanks, your information really helped me!!
jshepler22y ago
"DateTime dateDue = DateTime.Parse(strDateDue);//this doesn't work " Why doesn't it work? Did you get an error? It should work just fine. An alternative solution would be to have the database figure out if it's overdue or not and return a 1 or 0. That way you won't have to worry about format conversions. Assuming MS-SQL: SELECT OverDue = CASE WHEN DateDue BETWEEN getdate() AND DATEADD(Dd, 7, getdate()) THEN 1 ELSE 0 END or SELECT OverDue = CASE WHEN getdate() >= DATEADD(Dd, -7, DateDue) THEN 1 ELSE 0 END
sathyaselvi_v22y ago
i tried the convertion and comparision only, the code as follows string format; DateTime past,now; format="MM/dd/yyyy hh:mm:ss"; now=Convert.ToDateTime(System.DateTime.Now.ToString(format)); past=Convert.ToDateTime(System.DateTime.Today.ToString(format)); Response.Write(now+"
"); Response.Write(past+"
"); if(DateTime.Compare(now,past)==-1) Response.Write("Not Equal"); else Response.Write("Equal");
rulec44422y ago
I've made some progress, this is what I have now: I have a bound datagrid on an asp.net page. One column is filled with a DateDue, datetime. I am trying to check and if the date is less than a week out, I need to make the cell or text Red. This is what I've attempted and, of course, it doesn't work: private void dgExtractList_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { DateTime notifyDue = DateTime.Today.AddDays(7); if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView drv = (DataRowView)e.Item.DataItem; string dateDue = (drv.Row.ItemArray[3]).ToString(); DateTime dateDue = DateTime.Parse(strDateDue);//this doesn't work if(DateTime.Compare(dateDue, notifyDue) <= 7) { e.Item.Cells[3].BackColor = Color.Red; } } } I'm trying to compare a datetime in format yyyy-mm-dd 00:00:00.000 to format mm/dd/yyyy 00:00:00 AM - I don't know how to convert that. Any suggestions? Thanks for your help!!