Data binding Formatting the Cells

[Khizar Khan]

Hi,

I have a requirement where I have to compare dates which are in the binded data set to grid. The priority column has to be set to a value and format the cell color to red/orange/gree based on the value of Targetdt and warningdate which is available in the datasource binded to the grid.

I am doing the following.

void rGridViewTasks_ViewCellFormatting(object sender, CellFormattingEventArgs e)
        {
                if (e.CellElement.ColumnInfo.Name == "Priority")

            {

                //if ((DateTime)e.CellElement.RowInfo.Cells["TargetDt"].Value >= DateTime.Now )

                //{

                //    e.CellElement.BackColor = Color.DarkRed;

                //    e.CellElement.Value = "1";

                //}

                //else if (((DateTime)e.CellElement.RowInfo.Cells["WarningDate"].Value >= DateTime.Now) &&

                //     ((DateTime)e.CellElement.RowInfo.Cells["TargetDt"].Value < DateTime.Now))

                //{

                //    e.CellElement.BackColor = Color.DarkOrange;

                //    e.CellElement.Value = "2";

                //}

                //else

                //{

                //    e.CellElement.BackColor = Color.DarkGreen;

                //    e.CellElement.Value = "3";

                //}

            }

}

the above WarningDate and TargetDt columns are not added as the columns in the grid, hence they are coming as null and giving a exception.

I checked the rowinfo databounditem and it is also null. Please advice.

regards,
Khizar

[Alexander]

Hello Khizar,

Thank you for your question.

You can accomplish your scenario adding the TargetDt and WarningDate columns as invisible in RadGridView:

this.radGridView1.Columns["TargetDt"].IsVisible = false;

Then you can use their values in formatting events.

Keep in mind that ViewCellFormatting event is raised for every RadGridView cell. I suppose you do not aim to format, for example, the header row and the filter row depending on values in your hidden columns. I would advise you to format the data cells of the Priority column using the CellFormatting event of RadGridView.

The CellFormatting event is raised for data cells and new row cells. As your hidden columns do not have values for the new row, you should execute your formatting logic only for data rows:

private void rGridViewTasks_CellFormatting(object sender, CellFormattingEventArgs e)
{
    if (e.CellElement.RowElement is GridNewRowElement)
    {
        return;
    }

    if (e.CellElement.ColumnInfo.Name == "Priority")
    {
        // your formatting logic here
    }
}

I hope it helps you to accomplish your requirements.

Kind regards,
Alexander
the Telerik team