Highlight row based on conditions

Hi

I have a grid which I want to highlight rows based on conditions. for example, set back color of rows which have column x greater than 2 into red.   can I use ColumnFilters in data band for it. 

thanks in advance

Hi, 

Yes, you can – assuming you only want to apply a single appearance to the cells based on a single set of conditions. 

In other words, if you want to filter a column so that it detects values greater than 0 and apply an appearance to cells that do not meet that condition, you can do that. But if you want to detect multiple criteria and apply multiple appearances like for example: 

<0 = red

0 – 100 = Yellow

>100 = Green

Then you cannot do that using ColumnFilters. Filtering is a binary condition. A row is either filtered out or it's not, so you can only use to apply a single appearance. 

If you need more than one appearance, the best way to do that is to use the InitializeRow event. In fact, the InitializeRow event is probably better, anyway, because if you use ColumnFilters to apply the appearance, then that means your users cannot use the grid's filtering functionality for anything else. 

Thanks for reply. But as far as I know ColumnFilters just filter the rows based on conditions; which means it doesn't display those rows not meeting the criteria. but I want to change appearance of rows not just stop displaying them. how can I do that with ColumnFilters.

Hi, 

Okay, if that's what you want to do, then you need to set the RowFilterAction property and then define the FilteredInRowAppearance, FilteredOutRowAppearance, FilteredInCellAppearance, and/or FilteredOutCellAppearance that you want. 

private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
var layout = e.Layout;
var band = layout.Bands[0];
var ov = layout.Override;

ov.AllowRowFiltering = DefaultableBoolean.True;
ov.FilterUIType = FilterUIType.FilterRow;
ov.RowFilterAction = RowFilterAction.AppearancesOnly;
ov.FilteredInRowAppearance.BackColor = Color.Blue;
ov.FilteredInRowAppearance.ForeColor = Color.White;
ov.FilteredOutRowAppearance.BackColor = Color.Yellow;
ov.FilteredOutRowAppearance.ForeColor = Color.Black;
}

Thanks for reply. exactly what I need.