windowsforms-devexpress-dot-xtragrid-dot-columns-dot-gridcolumn-c02557fe.md
Gets or sets an expression that the unbound column uses to calculate its cell values. Columns with unbound expressions are non-editable.
Namespace : DevExpress.XtraGrid.Columns
Assembly : DevExpress.XtraGrid.v25.2.dll
NuGet Packages : DevExpress.Win.Grid, DevExpress.Win.Navigation
[DefaultValue("")]
[DXCategory("Data")]
[XtraSerializableProperty]
public string UnboundExpression { get; set; }
<DXCategory("Data")>
<DefaultValue("")>
<XtraSerializableProperty>
Public Property UnboundExpression As String
| Type | Default | Description |
|---|---|---|
| String | String.Empty |
A string that specifies an expression used to evaluate values for the current column.
|
Unbound columns can be populated in two ways.
Specify the UnboundExpression and the column will automatically calculate its cell values. Users are unable to edit cell values if the parent column employs unbound expressions to calculate these values.
Handle the ColumnView.CustomUnboundColumnData event to provide custom cell values to a column. This approach leaves column cells editable.
At design time, click the ellipsis button (…) next to the UnboundExpression property in the Visual Studio Properties window to invoke the Expression Editor (see the figure below). This editor allows you to build unbound expressions from field names, operators, constants, and mathematical functions. If the GridColumn.ShowUnboundExpressionMenu option is enabled, users can use the same editor at runtime to edit this column’s expression.
If you need to specify valid expressions in code, refer to the Expressions article for the expression syntax.
For more information about unbound columns, see Unbound Columns.
WinForms Grid: Unbound Columns.
The following code shows how to create an unbound column (Ext Price) and populate it with data using expressions. Data for this column is calculated according to the formula: [Quantity] * [UnitPrice] * (1 - [Discount]), which is set via the GridColumn.UnboundExpression property.
using DevExpress.XtraGrid.Columns;
GridColumn columnExtPrice = new GridColumn();
columnExtPrice.FieldName = "ExtPrice";
columnExtPrice.Caption = "Ext Price";
columnExtPrice.UnboundDataType = typeof(decimal);
columnExtPrice.UnboundExpression = "[Quantity] * [UnitPrice] * (1 - [Discount])";
gridView1.Columns.Add(columnExtPrice);
columnExtPrice.VisibleIndex = 0;
Imports DevExpress.XtraGrid.Columns
Dim columnExtPrice As GridColumn = New GridColumn()
columnExtPrice.FieldName = "ExtPrice"
columnExtPrice.Caption = "Ext Price"
columnExtPrice.UnboundDataType = GetType(Decimal)
columnExtPrice.UnboundExpression = "[Quantity] * [UnitPrice] * (1 - [Discount])"
GridView1.Columns.Add(columnExtPrice)
columnExtPrice.VisibleIndex = 0
See Also
ShowUnboundExpressionEditor(GridColumn)
UnboundExpressionEditorCreated