How Do I Change Change Gridview Color Based On Date

Question

0.00/5 (No votes)

See more:

hello can u please help me on this ..i want to to change the color of the row of gridview if the date is passed ...i am new to programming help me to solve this ...

Posted 29-Jan-14 19:30pm

vivek0041

Updated 29-Jan-14 19:52pm

v2

Add a Solution

Comments

Karthik_Mahalingam 30-Jan-14 1:48am

column or row ?? make sure

vivek0041 30-Jan-14 1:51am

sorry my mistake i want to change the color of row not column

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Karthik_Mahalingam · Answer 1 · 2014-01-29T19:57:00

Solution 2

Try this..

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
       {

           if (e.Row.RowType == DataControlRowType.DataRow)
           {
               DateTime date = (DateTime)DataBinder.Eval(e.Row.DataItem, "DateColumnofYourDataSource")   ;
               if (DateTime.Now > date )
                   e.Row.BackColor = System.Drawing.Color.Red;
               else
                   e.Row.BackColor = System.Drawing.Color.Green;
           }
       }

Posted 29-Jan-14 19:57pm

Karthik_Mahalingam

Comments

vivek0041 30-Jan-14 2:05am

Specified cast is not valid. this is the error m getting dear

vivek0041 30-Jan-14 2:06am

DateTime date = (DateTime)DataBinder.Eval(e.Row.DataItem, "duedate"); on this line

Siva Hyderabad 30-Jan-14 2:37am

5+

Karthik_Mahalingam 30-Jan-14 3:10am

Thanks SambasivaRao:)

Karthik_Mahalingam 30-Jan-14 3:10am

post your data source code

vivek0041 30-Jan-14 3:11am

if (e.Row.RowType == DataControlRowType.DataRow)
{
DateTime duedate = (DateTime)DataBinder.Eval(e.Row.DataItem,"duedate") ;
if (DateTime.Now < duedate )
e.Row.BackColor = System.Drawing.Color.Red;
else
e.Row.BackColor = System.Drawing.Color.Green;
}

Karthik_Mahalingam 30-Jan-14 3:13am

dudate is datetime or string ?

using datatable or list ?
post the datasource cdoe...

vivek0041 30-Jan-14 3:23am

duedate is datetime

vivek0041 30-Jan-14 3:24am

duedate is the colum name of my my database

Karthik_Mahalingam 30-Jan-14 3:31am

// i need these lines... datasource
GridView1.DataSource = dt;
GridView1.DataBind();

Karthik_Mahalingam 30-Jan-14 3:32am

post full codebehind code...

vivek0041 30-Jan-14 3:33am

protected void FillGrid(string orderby, string fieldname)
{
string userName = Session["username"].ToString();
string sql = "select a.taskid,a.taskdisc,a.assignedby,convert(char,a.taskdate,105) as taskdate,convert(char,a.duedate,105) as duedate,convert(char,a.completedDate,105) as completedDate,a.empname as assignedtoname,a.paramname as statusname,convert(char,a.remarkdate,105) as remarkdate,a.remarks from vw_taskreport a where a.assignedby='" + userName + "' ";
//string sql = "select a.taskid,a.taskdisc,a.assignedby,convert(char,a.taskdate,105) as taskdate,convert(char,a.duedate,105) as duedate,convert(char,a.completedDate,105) as completedDate,a.empname as assignedtoname,a.paramname as statusname,convert(char,a.remarkdate,105) as remarkdate,a.remarks from vw_taskreport a ";
if (DropDownList1.SelectedIndex > 0)
{
sql = sql + " and a.assignedto='" + DropDownList1.SelectedValue + "'";
}
if (TextBox1.Text.Length > 0)
{
sql = sql + " and a.duedate ='" + TextBox1.Text + "'";
}
if (DropDownList2.SelectedIndex > 0)
{
sql = sql + " and a.status='" + DropDownList2.SelectedValue + "'";
}
if (TextBox2.Text.Length > 0 )
{
sql = sql + " and a.completedDate = '" + TextBox3.Text + "'";
}
if (TextBox3.Text.Length > 0 )
{
sql = sql + " and a.taskdate = '" + TextBox2.Text + "'";
}
sql = sql + " order by " + fieldname + " " + orderby;
ds = obj.GetDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();

}
}

vivek0041 30-Jan-14 3:34am

this is the code for fill grid

Karthik_Mahalingam 30-Jan-14 3:37am

ok fine..
put a break point on this line and tell what value you are getting ..

string date = DataBinder.Eval(e.Row.DataItem, "duedate").ToString(); // use this line... dont use old one..

vivek0041 30-Jan-14 3:44am

CS0019: Operator '>' cannot be applied to operands of type 'System.DateTime' and 'string'getting this error

Karthik_Mahalingam 30-Jan-14 3:45am

comment these lines
//if (DateTime.Now > date)
// e.Row.BackColor = System.Drawing.Color.Red;
//else
// e.Row.BackColor = System.Drawing.Color.Green;

vivek0041 30-Jan-14 3:47am

code is running but no effects ..normal running

Karthik_Mahalingam 30-Jan-14 4:02am

post your gridview aspx code..

Karthik_Mahalingam 30-Jan-14 4:05am

<asp:GridView ID="GridView1" runat="server"
onrowdatabound="GridView1_RowDataBound1">

add this line in the gridview onrowdatabound="GridView1_RowDataBound1"

vivek0041 30-Jan-14 4:11am

i have added this ...u told to comment those line // e.Row.BackColor = System.Drawing.Color.Red;
//else
// e.Row.BackColor = System.Drawing.Color.Green;

Karthik_Mahalingam 30-Jan-14 4:12am

use this sampe and try to modify your code..

Karthik_Mahalingam 30-Jan-14 4:13am

<asp:GridView ID="GridView1" runat="server"
onrowdatabound="GridView1_RowDataBound1">
<columns>
<asp:TemplateField>
<itemtemplate>
some

Karthik_Mahalingam 30-Jan-14 4:14am

protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("duedate", typeof(DateTime));
dt.Rows.Add(DateTime.Now);
dt.Rows.Add(DateTime.Now.AddDays(-1));
dt.Rows.Add(DateTime.Now.AddDays(2));

GridView1.DataSource = dt;
GridView1.DataBind();

}

protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DateTime date = (DateTime)DataBinder.Eval(e.Row.DataItem, "duedate");
if (DateTime.Now > date)
e.Row.BackColor = System.Drawing.Color.Red;
else
e.Row.BackColor = System.Drawing.Color.Green;
}
}

vivek0041 30-Jan-14 4:36am

again same error.. Specified cast is not valid.

Karthik_Mahalingam 30-Jan-14 4:48am

change this convert(char,a.duedate,105) as duedate to

only duedate

remove this "convert(char,a.duedate,105) as"

vivek0041 30-Jan-14 4:57am

if i will remove this ...i will the date as well as time in grid view ...i want to see only date that's why i have converted that

Karthik_Mahalingam 30-Jan-14 5:00am

use this code..

protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DateTime date = DateTime.ParseExact(DataBinder.Eval(e.Row.DataItem, "duedate").ToString(), "dd/MM/yyyy", null);
if (DateTime.Now > date)
e.Row.BackColor = System.Drawing.Color.Red;
else
e.Row.BackColor = System.Drawing.Color.Green;
}
}

Karthik_Mahalingam 30-Jan-14 5:00am

ok then use convert(char,a.duedate,105) as duedate

vivek0041 30-Jan-14 5:05am

if (e.Row.RowType == DataControlRowType.DataRow)
{
string date = DataBinder.Eval(e.Row.DataItem, "DueDate").ToString();
DataRowView test = (System.Data.DataRowView)e.Row.DataItem;
DateTime dt = Convert.ToDateTime(test.Row["DueDate"].ToString());
int dtrslt = DateTime.Compare(dt, DateTime.Now);
if (dtrslt < 0)
e.Row.BackColor = System.Drawing.Color.Red;

else
{
e.Row.BackColor = System.Drawing.Color.Green;
}
e.Row.BackColor = System.Drawing.Color.Green;
}

this code is working on local machine but on server it shows error "String was not recognized as a valid DateTime." .....please help me to sort out this

Karthik_Mahalingam 30-Jan-14 5:11am

DateTime dt = DateTime.ParseExact(DataBinder.Eval(e.Row.DataItem, "duedate").ToString(), "dd/MM/yyyy", null);
use this code..

vivek0041 30-Jan-14 5:16am

ufff...same error brother

Karthik_Mahalingam 30-Jan-14 5:23am

what error ?
tell me how it is displaying in screen ? in the server..
30/01/2014 or 01/30/2014

vivek0041 30-Jan-14 5:31am

its just displaying "String was not recognized as a valid DateTime."

Karthik_Mahalingam 30-Jan-14 5:38am

tell me how it is displaying in screen ? in the server..
30/01/2014 or 01/30/2014

vivek0041 30-Jan-14 5:39am

30/01/2014

Karthik_Mahalingam 30-Jan-14 5:40am

just comment this whole section and tell me

if (e.Row.RowType == DataControlRowType.DataRow)
{
DateTime date = DateTime.ParseExact(DataBinder.Eval(e.Row.DataItem, "duedate").ToString(), "dd/MM/yyyy", null);
if (DateTime.Now > date)
e.Row.BackColor = System.Drawing.Color.Red;
else
e.Row.BackColor = System.Drawing.Color.Green;
}

vivek0041 30-Jan-14 5:43am

running but no color effect

vivek0041 30-Jan-14 5:49am

can u please give me your gmail address

Karthik_Mahalingam 30-Jan-14 5:51am

post your full code aspx and aspx.cs i will correct your code.. and send you..

vivek0041 30-Jan-14 5:56am

"String was not recognized as a valid DateTime." .....please help me to sort out this

vivek0041 30-Jan-14 5:56am

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Drawing;

public partial class AssignedTaskReport : System.Web.UI.Page
{
DataSet ds = new DataSet();
Class1 obj = new Class1();
protected void Page_Load(object sender, EventArgs e)
{

if (!IsPostBack)
{
ViewState["orderby"] = "asc";
Hidden1.Value = "Taskid";
FillGrid(ViewState["orderby"].ToString(), Hidden1.Value);
FillDropDown();

GridView1.Visible = false;

////databind();
}

}

protected void imgsearchbtn_Click(object sender, ImageClickEventArgs e)
{

ViewState["orderby"] = "asc";
Hidden1.Value = "Taskid";
FillGrid(ViewState["orderby"].ToString(), Hidden1.Value);
FillDropDown();
GridView1.Visible = true;
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
GridView1.Visible = false;
DropDownList1.ClearSelection();
TextBox1.Text = string.Empty;
DropDownList2.ClearSelection();
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;

}

protected void FillGrid(string orderby, string fieldname)
{
string userName = Session["username"].ToString();
string sql = "select a.taskid,a.taskdisc,a.assignedby,convert(char,a.taskdate,105) as taskdate,convert(char,a.duedate,105) as duedate,convert(char,a.completedDate,105) as completedDate,a.empname as assignedtoname,a.paramname as statusname,convert(char,a.remarkdate,105) as remarkdate,a.remarks from vw_taskreport a where a.assignedby='" + userName + "' ";
//string sql = "select a.taskid,a.taskdisc,a.assignedby,convert(char,a.taskdate,105) as taskdate,convert(char,a.duedate,105) as duedate ,convert(char,a.completedDate,105) as completedDate,a.empname as assignedtoname,a.paramname as statusname,convert(char,a.remarkdate,105) as remarkdate,a.remarks from vw_taskreport a ";
if (DropDownList1.SelectedIndex > 0)
{
sql = sql + " and a.assignedto='" + DropDownList1.SelectedValue + "'";
}
if (TextBox1.Text.Length > 0)
{
sql = sql + " and a.duedate ='" + TextBox1.Text + "'";
}
if (DropDownList2.SelectedIndex > 0)
{
sql = sql + " and a.status='" + DropDownList2.SelectedValue + "'";
}
if (TextBox2.Text.Length > 0 )
{
sql = sql + " and a.completedDate = '" + TextBox3.Text + "'";
}
if (TextBox3.Text.Length > 0 )
{
sql = sql + " and a.taskdate = '" + TextBox2.Text + "'";
}
sql = sql + " order by " + fieldname + " " + orderby;
ds = obj.GetDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();

}
}

protected void FillDropDown()
{
{
string s;
s = "select * from employee order by 2";
ds = obj.GetDataSet(s);
if (ds.Tables[0].Rows.Count > 0)
{
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "Empname";
DropDownList1.DataValueField = "username";
DropDownList1.DataBind();

DropDownList1.Items.Insert(0, "Select Employee Name");

}

}

}

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
string userName = Session["username"].ToString();
string sql = "select a.taskid,a.taskdi

vivek0041 30-Jan-14 6:30am

full code is not copied page is small

King Fisher · Answer 2 · 2014-01-29T19:37:00

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowType == DataControlRowType.DataRow)
{

 Label lbldate= (Label)e.Row.FindControl("id of your label"); //which one contain the date field in Gridview

datetime presentdate;
presentdate=System.Datetime.Now.Tostring();
if (lbldate.text> presentdate)
               {
                  
                   e.Row.BackColor = System.Drawing.Color.FromName("#ffcdea");
               }

else
{
  e.Row.BackColor = System.Drawing.Color.FromName("#FFFFFF");
}

}
}

TrushnaK · Answer 3 · 2014-01-29T20:16:00

Solution 4

use Gridview1_RowDataBound event

try like this(change in code as per your requirement):-

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{

    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        int dtrslt = DateTime.Compare(e.Row.DataItem("DATE_COLUMN_NAME"), Date.Now);
        if ( dtrslt < 0)
     e.Row.BackColor = System.Drawing.Color.Red;
                   //Or for hex color
    e.Row.BackColor = ColorTranslator.FromHtml("#D1ECC2");
        else
     e.Row.BackColor = System.Drawing.Color.yellow;
    //Or for hex color
            e.Row.BackColor = ColorTranslator.FromHtml("#E7B3B3")
    }
}

Posted 29-Jan-14 20:16pm

TrushnaK

Updated 29-Jan-14 20:42pm

v2

Comments

vivek0041 30-Jan-14 2:28am

CS1955: Non-invocable member 'System.Web.UI.WebControls.GridViewRow.DataItem' cannot be used like a method. error

TrushnaK 30-Jan-14 2:45am

try this:-
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView test = (System.Data.DataRowView)e.Row.DataItem;
DateTime dt = (DateTime) test.Row[4].ToString(); //Add your date column index here
int dtrslt = DateTime.Compare(dt, Date.Now);
if ( dtrslt < 0)
e.Row.BackColor = System.Drawing.Color.Red;
//Or for hex color
e.Row.BackColor = ColorTranslator.FromHtml("#D1ECC2");
else
e.Row.BackColor = System.Drawing.Color.yellow;
//Or for hex color
e.Row.BackColor = ColorTranslator.FromHtml("#E7B3B3")
}
}

vivek0041 30-Jan-14 3:00am

CS0030: Cannot convert type 'string' to 'System.DateTime'...now this error

vivek0041 30-Jan-14 3:02am

if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView test = (System.Data.DataRowView)e.Row.DataItem;
DateTime dt = (DateTime)test.Row["duedate"].ToString(); //Add your date column index here
int dtrslt = DateTime.Compare(dt, DateTime.Now.ToString());
if ( dtrslt < 0)
e.Row.BackColor = System.Drawing.Color.Red;

else
{
e.Row.BackColor = System.Drawing.Color.Yellow;
}

}
}
this is what i was doing and getting the arror

TrushnaK 30-Jan-14 3:11am

change this line
DateTime dt = (DateTime) test.Row[4].ToString();
to
DateTime dt = Convert.ToDateTime(test.Row[4].ToString());

vivek0041 30-Jan-14 3:22am

String was not recognized as a valid DateTime. now this error

vivek0041 30-Jan-14 4:59am

String was not recognized as a valid DateTime.

TrushnaK 30-Jan-14 5:35am

friend check what you get in
DateTime dt = Convert.ToDateTime(test.Row[4].ToString());
this line.. change your index test.Row[4].ToString().
and try....

or use DateTime.ParseExact() method for converting string to datetime..

How Do I Change Change Gridview Color Based On Date

3 solutions

Solution 2

Solution 1

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us