how to change cell color according to its DateTime value in dataGridView?

Question

0.00/5 (No votes)

See more:

I have a datagridview and it contains a column call 'Schedule Date'. When I am Running the program the values which are in 'Schedule Date' should be appear like this.
if the value is less than "DateTime.Today" , then that cell should be appear in RED colour and others should appear in GREEN color.
I am confuced. please help me to find a solution for this.
Thanks in Advance.

Posted 8-Oct-13 19:21pm

thasneemjambi

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeBlack · Answer 1 · 2013-10-08T19:38:00

XML

<asp:GridView runat="server" ID="gridMain" AutoGenerateColumns="False">
       <Columns>
           <asp:TemplateField>
               <ItemTemplate>
                   <div style='<%# Convert.ToDateTime(DataBinder.Eval(Container.DataItem ,"Schedule_Date")) >= DateTime.Now ? "background-color:green" : "background-color:red" %>'>
                       <%#Eval("Schedule_Date") %>
                   </div>
               </ItemTemplate>
           </asp:TemplateField>
           <asp:BoundField DataField="EmployeeName" HeaderText="Name" />
       </Columns>
   </asp:GridView>

thasneemjambi · Answer 2 · 2013-10-08T20:58:00

C#

foreach (DataGridViewRow row in DataGridViewRow1.Rows)
{
                var now = DateTime.Now;
                var cellDate = DateTime.Parse(row.Cells[14].Value.ToString());
                var forTenDays = now.AddDays(+10);

                if (now > cellDate)
                {
                    row.DefaultCellStyle.BackColor = Color.Red;
                }
                else if ((now < cellDate) && (cellDate < forTenDays))
                {
                    row.DefaultCellStyle.BackColor = Color.Yellow;
                }
                else
                {
                    row.DefaultCellStyle.BackColor = Color.LightGreen;
                }
}

how to change cell color according to its DateTime value in dataGridView?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to change cell color according to its DateTime value in dataGridView?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us