color coding rows

[Administrator]

hi,

i''d like to color code all detail rows according to the value of a certain field in each row, not affecting group headers. any ideas?

TIA

[Administrator]

You can use GridConditionalFormatDescriptor to do this. Below is a sample link.

//color rows and alternates rows if their Age value is between 30 and 40.
			GridConditionalFormatDescriptor format = new GridConditionalFormatDescriptor("specialColor");
			format.Expression = "[Age] > 30 And [Age] < 40";
			format.Appearance.AlternateRecordFieldCell.BackColor = Color.LightGoldenrodYellow;
			format.Appearance.AnyRecordFieldCell.BackColor = Color.LightBlue;
			this.gridGroupingControl1.TableDescriptor.ConditionalFormats.Add(format);

GroupingDataSample_3560.zip

[Administrator]

Thanks,

that''s great! i have a problem with a boolean field, or bit in sql.

format.Expression = "[Completed] = False";

format.Expression = "[Completed] = 0";

or just format.Expression = "[Completed]";

none seem to work.

i tried an integer field and it works.

tia

[Administrator]

having trouble with string fields too, such as format.Expression = "[Full/Empty] = ''E''";

[Administrator]

You use LIKE to work with strings (and bool values). You can also use match. The strings have to be in single quotes.

''OK is a checkbox column
format.Expression = "[OK] LIKE ''true''"

''states that start with N
format.Expression = "[State] LIKE ''N*''"

''only NC
format.Expression = "[State] LIKE ''NC''"

[Administrator]

Around the literals should be only one single quote on each side. I think the web interface has added the additional one you see.

[Administrator]

you guys should get half my salary! hehe!

[Frances]

What would the Format.Expression look like if the underlying data type is a SqlDateTime? For example I want to change the background colour of all rows with a CreatedAt date < ''2004-12-01''. The cell data looks like ''2004-12-07 12:34 PM'' etc.

This doesn''t work for me:
format.Expression = "[CreatedAt] < 2004-12-01";

What should I be using in this scenario?

[Administrator]

You would need to use the ''between'' operator to compare dates. Here is the section from the User Guide on between.

between - Checks if a date field value between the two values is listed in the right-hand operand. For example, [date] between {2/25/2004, 3/2/2004} returns 1 for any record whose date field is greater or equal 2/25/2004 and less than 3/2/2004. To represent the current date, use the token TODAY. To represent DateTime.MinValue, leave the first argument empty. To represent DateTime.MaxValue, leave the second argument empty. 

GridConditionalFormatDescriptor format = new GridConditionalFormatDescriptor("Before Dec");
format.Expression = "[CreateDate] between {,2004-12-01}";
format.Appearance.AlternateRecordFieldCell.BackColor = Color.LightGoldenrodYellow;
format.Appearance.AnyRecordFieldCell.BackColor = Color.LightGoldenrodYellow;
this.gridGroupingControl1.TableDescriptor.ConditionalFormats.Add(format);