Hi;
I am trying to highlight rows in a gridview when the data (date/time) Column1 is older than the data (date/time) in Column2. these collomns can be empty (null) therefore it get this errow message :"Object cannot be cast from DBNull to other types"

I would be grateful if anyone help me with that. this is my code

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        GridViewRow row = e.Row;
        if (row.DataItem == null)
        {
            return;
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {

            DateTime date1 = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Column1"));
            DateTime date2 = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Column2"));

            if (DateTime.Compare(date2, date1) < 0)
            {
                e.Row.BackColor = System.Drawing.Color.Plum;
            }
        }
    }

where do you get the error????.. unless I missing something this looks ok...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Thanks Gonzalo for your reply,
I get the error on these lines:
 DateTime date1 = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Column1"));
            DateTime date2 = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Column2"));
and i think because Column1 and Column2 contain empty cells(i.e. in the data source some time these columns should have empty cells and this cause the problem).

Well, you will get an error if you try to convert a blank value to datetime, optimize your code so that you convert to datetime only if the column has some value, avoid conversion in case of blank & null values.

Regards
Mike

Don't expect too much, too soon.

Mike how can i do that, could you please give me some advice

Well you can do something like below:

if ((DataBinder.Eval(e.Row.DataItem, "Column1") != DBNull.Value) && (DataBinder.Eval(e.Row.DataItem, "Column1") != string.Empty))
                {
                    //DateTime date1 = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Column1"));
                }

Regards
Mike

Don't expect too much, too soon.

Thanks Mike I did it in a different way but I think the way you have captured the blank values is much better therefore I have used your code.

Thanks very much.

Regards
rao