We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date


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

1 Reply

AD Administrator Syncfusion Team April 1, 2005 11:46 PM UTC

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);

Live Chat Icon For mobile
Up arrow icon