GridConditionalFormatDescriptor

[Administrator]

Hi,
I am trying to format my grid based on a criteria. My criteria is "[Column] not like '''' "

In other words, i need to format all the rows the value of a particular column is not null. I cant seem to find the operator that can do that for me. Any help would be great

[Administrator]

There is no special operator for doing a NOT LIKE, but you can check if a logical expression equals 0 to get the complement of the logical expression.

GridConditionalFormatDescriptor cfd = new GridConditionalFormatDescriptor("NotEmpty");
cfd.Expression = "( [Col2] LIKE '''' ) = 0" ;
cfd.Appearance.AnyRecordFieldCell.BackColor = Color.LightGoldenrodYellow;
this.gridGroupingControl1.TableDescriptor.ConditionalFormats.Add(cfd);