StyleFormatConditionBase.Expression Property

Gets or sets the Boolean expression. When it evaluates to true, the StyleFormatConditionBase.Appearance is applied to data. The Expression property is in effect when the StyleFormatConditionBase.Condition property is set to FormatConditionEnum.Expression.

Namespace: DevExpress.XtraEditors

Assembly: DevExpress.XtraEditors.v19.2.dll

Declaration

C#

[DefaultValue("")]
[XtraSerializableProperty]
public string Expression { get; set; }

VB.NET

<DefaultValue("")>
<XtraSerializableProperty>
Public Property Expression As String

Property Value

Type	Default	Description
String	String.Empty	A string that specifies the Boolean expression.

Example

The following example shows how to create a condition to style grid rows, and specify criteria for the condition using a string expression.

The condition’s criteria is specified by the StyleFormatConditionBase.Expression property. The expression selects rows that do not contain null in the Region field. Rows that match this condition will be painted in light pink.

The following image shows this condition applied to an XtraGrid control.

C#

using DevExpress.XtraGrid;

StyleFormatCondition condition1 = new DevExpress.XtraGrid.StyleFormatCondition();
condition1.Appearance.BackColor = Color.SeaShell;
condition1.Appearance.Options.UseBackColor = true;
condition1.Condition = FormatConditionEnum.Expression;
condition1.Expression = "[Region] != ?";
gridView1.FormatConditions.Add(condition1);

VB.NET

Imports DevExpress.XtraGrid

Dim condition1 As StyleFormatCondition = New DevExpress.XtraGrid.StyleFormatCondition()
condition1.Appearance.BackColor = Color.SeaShell
condition1.Appearance.Options.UseBackColor = True
condition1.Condition = FormatConditionEnum.Expression
condition1.Expression = "[Region] != ?"
GridView1.FormatConditions.Add(condition1)

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Expression property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-enable-users-to-design-pivotgridcontrol-format-conditions-at-runtime-t145142/CS/PivotGridFormatCondition/CustomConditionItems.cs#L27

    else
        return string.Format("{0}", fcondition.Expression);
return string.Format("Condition Item - Index {0}", Index);

how-to-enable-users-to-design-gridview-format-conditions-at-runtime-e3717/CS/GridViewFormatCondition/CustomConditionItems.cs#L26

    else
        return string.Format("{0}", fcondition.Expression);
return string.Format("Condition Item - Index {0}", Index);

how-to-implement-styleformatconditions-in-vgridcontrol-e4106/CS/StyleFormatConditionsForXtraVerticalGrid/Form1.cs#L39

condition1.Condition = FormatConditionEnum.Expression;
condition1.Expression = "[OrderCost] < 1000 AND [OrderCost] > 300";
condition1.ApplyToRow = false;

how-to-serialize-treelists-formatconditions-e1984/CS/E1984/SerializableFormatCondition.cs#L73

    Value2 = style.Value2;
    Expression = style.Expression;
}

how-to-change-appearance-priority-in-gridcontrol-e4869/CS/AppearancePrioritySample/Form1.cs#L29

condition1.ApplyToRow = false;
condition1.Expression = "[Value1] > 2";
condition1.Column = gridColumn3;

VB.NET

how-to-enable-users-to-design-pivotgridcontrol-format-conditions-at-runtime-t145142/VB/PivotGridFormatCondition/CustomConditionItems.vb#L25

Else
    Return String.Format("{0}", fcondition.Expression)
End If

how-to-enable-users-to-design-gridview-format-conditions-at-runtime-e3717/VB/GridViewFormatCondition/CustomConditionItems.vb#L24

Else
    Return String.Format("{0}", fcondition.Expression)
End If

how-to-implement-styleformatconditions-in-vgridcontrol-e4106/VB/StyleFormatConditionsForXtraVerticalGrid/Form1.vb#L42

condition1.Condition = FormatConditionEnum.Expression
condition1.Expression = "[OrderCost] < 1000 AND [OrderCost] > 300"
condition1.ApplyToRow = False

how-to-serialize-treelists-formatconditions-e1984/VB/E1984/SerializableFormatCondition.vb#L93

    Value2 = style.Value2
    Expression = style.Expression
End Sub

how-to-change-appearance-priority-in-gridcontrol-e4869/VB/AppearancePrioritySample/Form1.vb#L30

condition1.ApplyToRow = False
condition1.Expression = "[Value1] > 2"
condition1.Column = gridColumn3