GridColumn.ColumnType Property

Gets the column’s data type.

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v19.2.dll

Declaration

C#

[Browsable(false)]
public virtual Type ColumnType { get; }

VB.NET

<Browsable(False)>
Public Overridable ReadOnly Property ColumnType As Type

Property Value

Type	Description
Type	A System.Type value representing column data type.

Remarks

The code sample below illustrates how to highlight all DateTime columns in a grid.

C#

gridView1.CustomDrawCell += GridView1_CustomDrawCell;

private void GridView1_CustomDrawCell(object sender, RowCellCustomDrawEventArgs e)
{
    GridView view = sender as GridView;
    if (column.ColumnType == typeof(DateTime))
    {
        e.Cache.FillRectangle(Color.Salmon, e.Bounds);
        e.Appearance.DrawString(e.Cache, e.DisplayText, e.Bounds);
        e.Handled = true;
    }
}

VB.NET

Private gridView1.CustomDrawCell += AddressOf GridView1_CustomDrawCell

Private Sub GridView1_CustomDrawCell(ByVal sender As Object, ByVal e As RowCellCustomDrawEventArgs)
    Dim view As GridView = TryCast(sender, GridView)
    If column.ColumnType Is GetType(Date) Then
        e.Cache.FillRectangle(Color.Salmon, e.Bounds)
        e.Appearance.DrawString(e.Cache, e.DisplayText, e.Bounds)
        e.Handled = True
    End If
End Sub

Note

Columns return valid ColumnType property values only after a Grid is completely initialized. Call the GridControl.ForceInitialize() method to ensure you do not read the ColumnType property too early.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ColumnType 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-gridview-format-conditions-at-runtime-e3717/CS/GridViewFormatCondition/CondititonItemControl.cs#L36

    currentFormatCondition = item.Condition;
    CreateValues(item.Condition.Column.ColumnType);
}

how-to-add-a-custom-filter-item-into-the-date-filter-popup-e5172/CS/MainForm.cs#L18

foreach(GridColumn column in myGridView1.Columns)
    if(column.ColumnType == typeof(DateTime))
        column.OptionsFilter.FilterPopupMode = FilterPopupMode.Date;

how-to-generate-a-live-report-based-on-gridcontrol-content-t272175/CS/WindowsFormsApplication1/GridReportExtensions/SnapReportForGridGenerator.cs#L174

static Type GetColType(GridColumn gridCol) {
    return gridCol.ColumnType;
}

gridlookupedit-how-to-filter-data-in-all-visible-columns-using-the-contains-condition-e1985/CS/GridLookUpEdit_MultiAutoSearch/CustomGridControl.cs#L34

{
    if (col.Visible && col.ColumnType == typeof(string))
        columnsOperators.Add(new BinaryOperator(col.FieldName, exp, BinaryOperatorType.Like));

VB.NET

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

    currentFormatCondition = item.Condition
    CreateValues(item.Condition.Column.ColumnType)
Else

how-to-add-a-custom-filter-item-into-the-date-filter-popup-e5172/VB/MainForm.vb#L20

For Each column As GridColumn In myGridView1.Columns
    If column.ColumnType Is GetType(DateTime) Then
        column.OptionsFilter.FilterPopupMode = FilterPopupMode.Date

how-to-generate-a-live-report-based-on-gridcontrol-content-t272175/VB/WindowsFormsApplication1/GridReportExtensions/SnapReportForGridGenerator.vb#L181

Private Function GetColType(ByVal gridCol As GridColumn) As Type
    Return gridCol.ColumnType
End Function

gridlookupedit-how-to-filter-data-in-all-visible-columns-using-the-contains-condition-e1985/VB/GridLookUpEdit_MultiAutoSearch/CustomGridControl.vb#L32

For Each col As GridColumn In Columns
    If col.Visible AndAlso col.ColumnType Is GetType(String) Then
        columnsOperators.Add(New BinaryOperator(col.FieldName, exp, BinaryOperatorType.Like))