How to change backcolor row in Janus Grid with condition

Question

How can I change the backcolor row GridEx(GridJanus) with a condition in c#

thanks

This is not clear enough - can you show us some code?? What have you done so far?? What **condition** do you want to base your decision on?? You need to elaborate a bit more.... — marc_s, Dec 10 '11 at 13:22

score 5 · Answer 1 · answered Dec 10 '11 at 13:34

I can't link to it directly, but I found this in a post by Ravi Kota on the Janus Systems forums. I'm not able to test this at present and it is an older post... Conceptually it looks right though.

GridEXFormatCondition fc;

fc = new GridEXFormatCondition(GridName.RootTable.Columns[ColumnName], ConditionOperator.GreaterThan, 0);

fc.FormatStyle.ForeColor = Color.Blue;

GridName.RootTable.FormatConditions.Add(fc);

score 1 · Answer 2 · answered Jul 12 '12 at 10:44

On LoadingRow event format row:

private void MyGridEX_LoadingRow(object sender, Janus.Windows.GridEX.RowLoadEventArgs e)
    {
        if (e.Row.RowType == Janus.Windows.GridEX.RowType.Record)
        {
            if ((bool)e.Row.Cells[0].Value)
            {
                Janus.Windows.GridEX.GridEXFormatStyle style = new Janus.Windows.GridEX.GridEXFormatStyle();
                style.ForeColor = Color.Red;
                e.Row.RowStyle = style;
            }
        }
    }

score 1 · Accepted Answer · edited Dec 11 '11 at 10:47

private void Grd_Detail_FormattingRow(object sender, Janus.Windows.GridEX.RowLoadEventArgs e)
{
    int i = 1;
    for (i = 0; i < Grd_Detail.RowCount; i++)
    {
        string s = Grd_Detail.GetRow(i).Cells["FN"].Value.ToString();
        if (s == "True")
        {
            if (e.Row.RowType == Janus.Windows.GridEX.RowType.Record)
            {                 
                Janus.Windows.GridEX.GridEXFormatStyle rowcol = new GridEXFormatStyle();
                rowcol.BackColor = Color.LightGreen;
                Grd_Detail.GetRow(i).RowStyle = rowcol;
            }
        }
    }
}

How to change backcolor row in Janus Grid with condition

3 Answers3