Cell Values, Editors, and Validation

A focused cell

ColumnView.GetFocusedValue
ColumnView.FocusedValue

ColumnView.SetFocusedValue

A cell of a focused row

ColumnView.GetFocusedRowCellValue
ColumnView.GetFocusedRowCellDisplayText

ColumnView.SetFocusedRowCellValue

Any row cell

ColumnView.GetRowCellValue
ColumnView.GetRowCellDisplayText

ColumnView.SetRowCellValue

A cell value in an underlying data source

ColumnView.GetListSourceRowCellValue

A currently edited cell

ColumnView.EditingValue

ColumnView.EditingValue

string cellValue;
cellValue = gridView1.GetRowCellValue(2, "ID").ToString();

Dim CellValue As String 
CellValue = GridView1.GetRowCellValue(2, "ID")

string cellValue = gridView1.GetFocusedDisplayText();

Dim cellValue As String = GridView1.GetFocusedDisplayText()

gridView1.SetRowCellValue(gridView1.FocusedRowHandle, gridView1.FocusedColumn, "New Value");
//or 
gridView1.SetFocusedValue("New Value");

gridView1.SetRowCellValue(gridView1.FocusedRowHandle, gridView1.FocusedColumn, "New Value")
'or 
gridView1.SetFocusedValue("New Value")

    BaseEdit edit = null;
    private void gridView1_ShownEditor(object sender, EventArgs e)
    {
        GridView view = sender as GridView;
        edit = view.ActiveEditor;
        edit.EditValueChanged += edit_EditValueChanged;       
    }

    void edit_EditValueChanged(object sender, EventArgs e)
    {
        gridView1.PostEditor();
    }

    private void gridView1_HiddenEditor(object sender, EventArgs e)
    {
        edit.EditValueChanged -= edit_EditValueChanged;
        edit = null;
    }

    Private edit As BaseEdit = Nothing 
    Private Sub gridView1_ShownEditor(ByVal sender As Object, ByVal e As EventArgs)
        Dim view As GridView = TryCast(sender, GridView)
        edit = view.ActiveEditor
        AddHandler edit.EditValueChanged, AddressOf edit_EditValueChanged
    End Sub 

    Private Sub edit_EditValueChanged(ByVal sender As Object, ByVal e As EventArgs)
        gridView1.PostEditor()
    End Sub 

    Private Sub gridView1_HiddenEditor(ByVal sender As Object, ByVal e As EventArgs)
        RemoveHandler edit.EditValueChanged, AddressOf edit_EditValueChanged
        edit = Nothing 
    End Sub 

gridView.CellValueChanged += (sender, e) => {
    GridView view = sender as GridView;
    if (e.Column.FieldName == "Length") {
        double doubleVal = (double)e.Value;
        view.SetRowCellValue(e.RowHandle, "Mark", doubleVal > 10);
    }
};

AddHandler gridView.CellValueChanged, Sub(sender, e)
    Dim view As GridView = TryCast(sender, GridView)
    If e.Column.FieldName = "Length" Then 
        Dim doubleVal As Double = CDbl(e.Value)
        view.SetRowCellValue(e.RowHandle, "Mark", doubleVal > 10)
    End If 
End Sub 

    // Assign a repository item to a column             
    RepositoryItemToggleSwitch edit = new RepositoryItemToggleSwitch();
    gridControl.RepositoryItems.Add(edit);
    gridView.Columns["Mark"].ColumnEdit = edit;

    ' Assign a repository item to a column             
    Dim edit As New RepositoryItemToggleSwitch()
    gridControl.RepositoryItems.Add(edit)
    gridView.Columns("Mark").ColumnEdit = edit

using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraEditors.Repository;

//create a repository item 
RepositoryItemProgressBar ieProgress = new RepositoryItemProgressBar();
gridControl1.RepositoryItems.Add(ieProgress);
ieProgress.KeyPress += IeProgress_KeyPress;

//assign repository item 
colRelevance.ColumnEdit = ieProgress;
//or 
private void GridView1_CustomRowCellEdit(object sender, CustomRowCellEditEventArgs e) {
    if (e.Column == colRelevance) e.RepositoryItem = ieProgress;
}

//handle + and - keys press 
private void IeProgress_KeyPress(object sender, KeyPressEventArgs e) {
    int i = 0;
    if (gridView1.ActiveEditor == null) return;

    if (e.KeyChar == '+') {
        i = (int)gridView1.ActiveEditor.EditValue;
        if (i < 100)
            gridView1.ActiveEditor.EditValue = i + 1;
    }
    if (e.KeyChar == '-') {
        i = (int)gridView1.ActiveEditor.EditValue;
        if (i > 0)
            gridView1.ActiveEditor.EditValue = i - 1;
    }
}

Imports DevExpress.XtraGrid.Views.Grid
Imports DevExpress.XtraEditors.Repository

'create a repository item 
Private ieProgress As New RepositoryItemProgressBar()
gridControl1.RepositoryItems.Add(ieProgress)
Private ieProgress.KeyPress += AddressOf IeProgress_KeyPress

'assign repository item 
colRelevance.ColumnEdit = ieProgress
'or 
private void GridView1_CustomRowCellEdit(Object sender, CustomRowCellEditEventArgs e)
  If e.Column = colRelevance Then 
      e.RepositoryItem = ieProgress
  End If 

'handle + and - keys press 
private void IeProgress_KeyPress(Object sender, KeyPressEventArgs e)
  Dim i As Integer = 0
  If gridView1.ActiveEditor Is Nothing Then 
      Return 
  End If 

  If e.KeyChar = "+"c Then 
      i = CInt(Math.Truncate(gridView1.ActiveEditor.EditValue))
      If i < 100 Then 
          gridView1.ActiveEditor.EditValue = i + 1
      End If 
  End If 
  If e.KeyChar = "-"c Then 
      i = CInt(Math.Truncate(gridView1.ActiveEditor.EditValue))
      If i > 0 Then 
          gridView1.ActiveEditor.EditValue = i - 1
      End If 
  End If 

    // Create the Commands column editor 
    RepositoryItemButtonEdit commandsEdit = new RepositoryItemButtonEdit { AutoHeight = false, Name = "CommandsEdit", TextEditStyle = TextEditStyles.HideTextEditor };
    commandsEdit.Buttons.Clear();
    commandsEdit.Buttons.AddRange(new EditorButton[] {
    new EditorButton(ButtonPredefines.Glyph, "Edit", -1, true, true, false, ImageLocation.MiddleLeft, DemoHelper.GetEditImage()),
    new EditorButton(ButtonPredefines.Glyph, "Delete", -1, true, true, false, ImageLocation.MiddleLeft, DemoHelper.GetDeleteImage())});

    // Create an unbound Commands column 
    GridColumn _commandsColumn = gridView.Columns.AddField("Commands");
    _commandsColumn.UnboundType = UnboundColumnType.Object;
    _commandsColumn.Visible = true;
    _commandsColumn.Width = 100;

    // Hide commandsColumn from EditForm 
    _commandsColumn.OptionsEditForm.Visible = DevExpress.Utils.DefaultBoolean.False;

    // Display commands only for focused row 
    gridView.CustomRowCellEdit += (s, e) => {
        if (e.RowHandle == gridView.FocusedRowHandle && e.Column == _commandsColumn)
            e.RepositoryItem = commandsEdit;
    };
    gridView.CustomRowCellEditForEditing += (s, e) => {
        if (e.RowHandle == gridView.FocusedRowHandle && e.Column == _commandsColumn)
            e.RepositoryItem = commandsEdit;
    };

    // Allow only commandsColumn to be edited 
    gridView.ShowingEditor += (s, e) => {
        e.Cancel = gridView.FocusedColumn != _commandsColumn;
    };

    gridView.OptionsEditForm.ShowOnDoubleClick = DevExpress.Utils.DefaultBoolean.False;
    gridView.OptionsEditForm.ShowOnEnterKey = DevExpress.Utils.DefaultBoolean.False;
    gridView.OptionsEditForm.ShowOnF2Key = DevExpress.Utils.DefaultBoolean.False;
    gridView.OptionsBehavior.EditingMode = GridEditingMode.EditFormInplace;

    // Perform a specific action when an EditorButton is clicked 
    commandsEdit.ButtonClick += (s, e) => {
        switch (e.Button.Caption) {
            case "Edit":
                // Start edit a row using EditForm 
                gridView.CloseEditor();
                gridView.ShowEditForm();
                break;
            case "Delete":
                // Delete focused row 
                gridControl.BeginInvoke(new MethodInvoker(() => { gridView.DeleteRow(gridView.FocusedRowHandle); }));
                break;
        }
    };

    ' Create the Commands column editor 
    Dim commandsEdit As RepositoryItemButtonEdit = New RepositoryItemButtonEdit With {.AutoHeight = False, .Name = "CommandsEdit", .TextEditStyle = TextEditStyles.HideTextEditor}
    commandsEdit.Buttons.Clear()
    commandsEdit.Buttons.AddRange(New EditorButton() {
        New EditorButton(ButtonPredefines.Glyph, "Edit", -1, True, True, False, ImageLocation.MiddleLeft, DemoHelper.GetEditImage()),
        New EditorButton(ButtonPredefines.Glyph, "Delete", -1, True, True, False, ImageLocation.MiddleLeft, DemoHelper.GetDeleteImage())
    })

    ' Create an unbound Commands column 
    Dim _commandsColumn As GridColumn = gridView.Columns.AddField("Commands")
    _commandsColumn.UnboundType = UnboundColumnType.Object 
    _commandsColumn.Visible = True 
    _commandsColumn.Width = 100

    ' Hide commandsColumn from EditForm 
    _commandsColumn.OptionsEditForm.Visible = DevExpress.Utils.DefaultBoolean.False 

    ' Display commands only for focused row 
    AddHandler gridView.CustomRowCellEdit, Sub(s, e)
        If e.RowHandle = gridView.FocusedRowHandle AndAlso e.Column Is _commandsColumn Then 
            e.RepositoryItem = commandsEdit
        End If 
    End Sub 
    AddHandler gridView.CustomRowCellEditForEditing, Sub(s, e)
        If e.RowHandle = gridView.FocusedRowHandle AndAlso e.Column Is _commandsColumn Then 
            e.RepositoryItem = commandsEdit
        End If 
    End Sub 

    ' Allow only commandsColumn to be edited 
    AddHandler gridView.ShowingEditor, Sub(s, e) e.Cancel = gridView.FocusedColumn <> _commandsColumn

    gridView.OptionsEditForm.ShowOnDoubleClick = DevExpress.Utils.DefaultBoolean.False 
    gridView.OptionsEditForm.ShowOnEnterKey = DevExpress.Utils.DefaultBoolean.False 
    gridView.OptionsEditForm.ShowOnF2Key = DevExpress.Utils.DefaultBoolean.False 
    gridView.OptionsBehavior.EditingMode = GridEditingMode.EditFormInplace

    ' Perform a specific action when an EditorButton is clicked 
    AddHandler commandsEdit.ButtonClick, Sub(s, e)
        Select Case e.Button.Caption
            Case "Edit" 
                ' Start edit a row using EditForm 
                gridView.CloseEditor()
                gridView.ShowEditForm()
            Case "Delete" 
                ' Delete focused row 
                gridControl.BeginInvoke(New MethodInvoker(Sub() gridView.DeleteRow(gridView.FocusedRowHandle)))
        End Select 
    End Sub 

RepositoryItemSpinEdit spinEdit = new RepositoryItemSpinEdit();
RepositoryItemCalcEdit calcEdit = new RepositoryItemCalcEdit();

gridView.Columns["Length"].ShowButtonMode = ShowButtonModeEnum.ShowAlways;

// Handle this event to assign editors to individual cells 
gridView.CustomRowCellEdit += (sender, e) => {
    GridView view = sender as GridView;
    if (e.Column.FieldName == "Length") {
        bool boolVal = (bool)view.GetRowCellValue(e.RowHandle, "Mark");
        if (boolVal)
            e.RepositoryItem = spinEdit;
        else 
            e.RepositoryItem = calcEdit;
    }
};

Dim spinEdit As New RepositoryItemSpinEdit()
Dim calcEdit As New RepositoryItemCalcEdit()

gridView.Columns("Length").ShowButtonMode = ShowButtonModeEnum.ShowAlways

' Handle this event to assign editors to individual cells 
AddHandler gridView.CustomRowCellEdit, Sub(sender, e)
    Dim view As GridView = TryCast(sender, GridView)
    If e.Column.FieldName = "Length" Then 
        Dim boolVal As Boolean = CBool(view.GetRowCellValue(e.RowHandle, "Mark"))
        If boolVal Then 
            e.RepositoryItem = spinEdit
        Else 
            e.RepositoryItem = calcEdit
        End If 
    End If 
End Sub 

gridView.OptionsView.ShowButtonMode = ShowButtonModeEnum.ShowAlways;

RepositoryItemButtonEdit riButtonEditEnabled = new RepositoryItemButtonEdit();
riButtonEditEnabled.Buttons.Clear();
riButtonEditEnabled.Buttons.Add(new EditorButton(ButtonPredefines.Plus, "Copy cell value"));
riButtonEditEnabled.Buttons.Add(new EditorButton(ButtonPredefines.Delete, "Clear this cell"));

RepositoryItemButtonEdit riButtonEditDisabled = new RepositoryItemButtonEdit();
// Create a similar RepositoryItem  
riButtonEditDisabled.Assign(riButtonEditEnabled);
// Disable all buttons 
riButtonEditDisabled.Buttons.ToList<EditorButton>().ForEach(button => button.Enabled = false);

gridView.CustomRowCellEdit += (s, e) => {
    if (e.Column.FieldName == "Notes") {
        GridView view = s as GridView;
        bool actionsAvailable = Convert.ToBoolean(view.GetRowCellValue(e.RowHandle,"Mark"));
        e.RepositoryItem = actionsAvailable ? riButtonEditEnabled : riButtonEditDisabled;
    }
};

gridView.OptionsView.ShowButtonMode = ShowButtonModeEnum.ShowAlways

Dim riButtonEditEnabled As New RepositoryItemButtonEdit()
riButtonEditEnabled.Buttons.Clear()
riButtonEditEnabled.Buttons.Add(New EditorButton(ButtonPredefines.Plus, "Copy cell value"))
riButtonEditEnabled.Buttons.Add(New EditorButton(ButtonPredefines.Delete, "Clear this cell"))

Dim riButtonEditDisabled As New RepositoryItemButtonEdit()
' Create a similar RepositoryItem  
riButtonEditDisabled.Assign(riButtonEditEnabled)
' Disable all buttons 
riButtonEditDisabled.Buttons.ToList().ForEach(Sub(button) button.Enabled = False)

AddHandler gridView.CustomRowCellEdit, Sub(s, e)
    If e.Column.FieldName = "Notes" Then 
        Dim view As GridView = TryCast(s, GridView)
        Dim actionsAvailable As Boolean = Convert.ToBoolean(view.GetRowCellValue(e.RowHandle,"Mark"))
        e.RepositoryItem = If(actionsAvailable, riButtonEditEnabled, riButtonEditDisabled)
    End If 
End Sub 

using DevExpress.XtraEditors.Repository;

// In-place editors used in display and edit modes respectively. 
RepositoryItem editorForDisplay, editorForEditing;

private void Form1_Load(object sender, EventArgs e) {
    // Initialize the editors and assign the default editor to a column. 
    editorForDisplay = new RepositoryItemProgressBar();
    editorForEditing = new RepositoryItemSpinEdit();
    gridView1.GridControl.RepositoryItems.AddRange( 
      new RepositoryItem[] { editorForDisplay, editorForEditing });
    gridView1.Columns["Quantity"].ColumnEdit = editorForDisplay;
}

// Provide the editor for in-place editing. 
private void gridView1_CustomRowCellEditForEditing(object sender, 
  CustomRowCellEditEventArgs e) {
    if (e.Column.FieldName == "Quantity")
        e.RepositoryItem = editorForEditing;
}

Imports DevExpress.XtraEditors.Repository

' In-place editors used in display and edit modes respectively. 
Dim editorForDisplay, editorForEditing As RepositoryItem

Private Sub Form1_Load(ByVal sender As System.Object, _ 
  ByVal e As System.EventArgs) Handles MyBase.Load
    ' Initialize the editors and assign the default editor to a column. 
    editorForDisplay = New RepositoryItemProgressBar()
    editorForEditing = New RepositoryItemSpinEdit()
    gridView1.GridControl.RepositoryItems.AddRange( _
      New RepositoryItem() {editorForDisplay, editorForEditing})
    gridView1.Columns("Quantity").ColumnEdit = editorForDisplay
End Sub 

' Provide the editor for in-place editing. 
Private Sub gridView1_CustomRowCellEditForEditing(ByVal sender As System.Object, _
  ByVal e As DevExpress.XtraGrid.Views.Grid.CustomRowCellEditEventArgs) _
  Handles gridView1.CustomRowCellEditForEditing
    If e.Column.FieldName = "Quantity" Then 
        e.RepositoryItem = editorForEditing
    End If 
End Sub 

BaseView.ShowEditor

Invokes the focused cell's editor

BaseView.HideEditor

Closes the currently active editor and discards any changes

BaseView.CloseEditor

Saves any changes made and closes the currently active editor

BaseView.PostEditor

Saves any changes made without closing the currently active editor

BaseView.ActiveEditor

Retrieves the currently active editor

ColumnView.ShownEditor

Fires whenever an in-place editor activates. The code below automatically sets the current date and opens the DateEdit popup when end-users activate the "Order Date" column editor.

using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraEditors;
//. . . 
gridView1.ShownEditor += GridView1_ShownEditor;
//. . . 
private void GridView1_ShownEditor(object sender, EventArgs e) {
    GridView View = sender as GridView;
    if (View.FocusedColumn == colOrderDate) {
        // adding the current date  
        View.EditingValue = DateTime.Today;
        // obtaining the active editor  
        DateEdit editor = View.ActiveEditor as DateEdit;
        // invoking the editor's popup window  
        editor.ShowPopup();
    }
}

Imports DevExpress.XtraGrid.Views.Grid
Imports DevExpress.XtraEditors
'. . . 
Private gridView1.ShownEditor += AddressOf GridView1_ShownEditor
'. . . 
Private Sub GridView1_ShownEditor(ByVal sender As Object, ByVal e As EventArgs)
    Dim View As GridView = TryCast(sender, GridView)
    If View.FocusedColumn = colOrderDate Then 
        ' adding the current date  
        View.EditingValue = Date.Today
        ' obtaining the active editor  
        Dim editor As DateEdit = TryCast(View.ActiveEditor, DateEdit)
        ' invoking the editor's popup window  
        editor.ShowPopup()
    End If 
End Sub 

ColumnView.HiddenEditor

Fires whenever an in-place editor closes. In the sample below, focus automatically moves to the cell below after an editor for the current cell closes. This allows your end-users to quickly change values of multiple cells that belong to the same column by entering new values and pressing Enter (or Escape). This code will not be executed when end-users work with a New Item Row.

using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraEditors;
//. . . 
gridView1.HiddenEditor += GridView1_HiddenEditor;
//. . . 
private void GridView1_HiddenEditor(object sender, EventArgs e) {
    GridView View = sender as GridView;
    if (View.FocusedRowHandle == GridControl.NewItemRowHandle) return;
    if (View.FocusedRowHandle == View.RowCount - 1)
        View.FocusedRowHandle = 0;
    else 
        View.FocusedRowHandle++;
    View.ShowEditor();
}

Imports DevExpress.XtraGrid.Views.Grid
Imports DevExpress.XtraEditors
'. . . 
Private gridView1.HiddenEditor += AddressOf GridView1_HiddenEditor
'. . . 
Private Sub GridView1_HiddenEditor(ByVal sender As Object, ByVal e As EventArgs)
    Dim View As GridView = TryCast(sender, GridView)
    If View.FocusedRowHandle = GridControl.NewItemRowHandle Then 
        Return 
    End If 
    If View.FocusedRowHandle = View.RowCount - 1 Then 
        View.FocusedRowHandle = 0
    Else 
        View.FocusedRowHandle += 1
    End If 
    View.ShowEditor()
End Sub 

GridOptionsBehavior.EditingMode

Allows you turn on the Edit Form and select its display mode.

GridView.ShowEditForm
GridView.HideEditForm

Call these methods to manually display and hide an Edit Form.

GridOptionsEditForm.ActionOnModifiedRowChange

Specifies whether to show confirmation dialogs when end-users modify records.

GridOptionsEditForm.ShowUpdateCancelPanel

Gets or sets whether or not the "Update" and "Cancel" buttons should be displayed. When these buttons are hidden, end-users can still utilize hotkeys to save (Ctrl+Enter) or discard (Escape) changes.

GridOptionsEditForm.BindingMode

Specifies whether to pass changes to a Data Grid immediately after an end-user moves focus to another Edit Form field, or only after all changes have been accepted.

GridOptionsEditForm.FormCaptionFormat

Allows you to modify a caption of a floating Edit Form.

GridView.EditFormShowing

Fires when the Edit Form is about to be shown, and allows you to forcibly hide the Edit Form when you do not want users to edit specific cell values. In the Prevent the Edit Form from Showing demo you cannot edit odd rows.

gridView.OptionsBehavior.EditingMode = GridEditingMode.EditForm;

//This event occurs when the Edit Form is about to be displayed. 
//  Set the Allow parameter to false to prevent the Edit Form from being displayed.  
gridView.EditFormShowing += (s, e) => {
    if (e.RowHandle % 2 == 0)
        e.Allow = false;
};

gridView.OptionsBehavior.EditingMode = GridEditingMode.EditForm

'This event occurs when the Edit Form is about to be displayed. 
'  Set the Allow parameter to false to prevent the Edit Form from being displayed.  
AddHandler gridView.EditFormShowing, Sub(s, e)
    If e.RowHandle Mod 2 = 0 Then 
        e.Allow = False 
    End If 
End Sub 

gridView.OptionsBehavior.EditingMode = GridEditingMode.EditForm;
DateEdit dateEdit = null;

// This event occurs when the EditForm is about to be displayed and allows accessing its editors 
gridView.EditFormPrepared += (s, e) => {
    // The e.BindableControls collection contains a list of editors located onto the EditForm 
    foreach (Control item in e.BindableControls) {
        dateEdit = item as DateEdit;
        if (dateEdit != null) {
            // Focus the DateEdit editor 
            gridControl.BeginInvoke(new MethodInvoker(() => { dateEdit.Focus(); }));
            return;
        }
    }
};

gridView.OptionsBehavior.EditingMode = GridEditingMode.EditForm
Dim dateEdit As DateEdit = Nothing 

' This event occurs when the EditForm is about to be displayed and allows accessing its editors 
AddHandler gridView.EditFormPrepared, Sub(s, e)
    ' The e.BindableControls collection contains a list of editors located onto the EditForm 
    For Each item As Control In e.BindableControls
        dateEdit = TryCast(item, DateEdit)
        If dateEdit IsNot Nothing Then 
            ' Focus the DateEdit editor 
            gridControl.BeginInvoke(New MethodInvoker(Sub() dateEdit.Focus()))
            Return 
        End If 
    Next item
End Sub 

GridColumn.OptionsEditForm

Provides access to layout settings that affect how an editor for this specific column looks within an Edit Form (see below).

OptionsColumnEditForm.UseEditorColRowSpan

Disable this setting to set custom column and row spans for an editor.

OptionsColumnEditForm.ColumnSpan
OptionsColumnEditForm.RowSpan

Specify the number of Edit Form columns and/or rows across which an editor stretches.

OptionsColumnEditForm.Caption
OptionsColumnEditForm.CaptionLocation

Allow you to modify the editor caption and its relative position.

OptionsColumnEditForm.Visible
OptionsColumnEditForm.VisibleIndex

Use these properties to hide and re-arrange column editors.

OptionsColumnEditForm.StartNewRow

Set this option to true to move the editor to a new row.

using DevExpress.XtraGrid.Views.Grid;
//custom edit form 
public class AdvancedEditForm : EditFormUserControl {
    public AdvancedEditForm() {
        InitializeComponent();
        //bind the EditValue of the textEdit3 editor to the "Price" data field 
        this.SetBoundFieldName(textEdit3, "Price");
        this.SetBoundPropertyName(textEdit3, "EditValue");
    }
}

//use the custom edit form in non-master-detail Data Grids 
gridView1.OptionsEditForm.CustomEditFormLayout = new AdvancedEditForm();

//use custom edit forms for detail Views 
void gridControl1_ViewRegistered(object sender, DevExpress.XtraGrid.ViewOperationEventArgs e) {
    GridView detailCloneView = e.View as GridView;
    if(detailCloneView.LevelName == "Order_Details")
        detailCloneView.OptionsEditForm.CustomEditFormLayout = new AdvancedEditForm(); 
}

Imports DevExpress.XtraGrid.Views.Grid
'custom edit form 
Public Class AdvancedEditForm
  Inherits EditFormUserControl

    Public Sub New()
        InitializeComponent()
        'bind the EditValue of the textEdit3 editor to the "Price" data field 
        Me.SetBoundFieldName(textEdit3, "Price")
        Me.SetBoundPropertyName(textEdit3, "EditValue")
    End Sub 
End Class 

'use the custom edit form in non-master-detail Data Grids 
gridView1.OptionsEditForm.CustomEditFormLayout = New AdvancedEditForm()

'use custom edit forms for detail Views 
void gridControl1_ViewRegistered(Object sender, DevExpress.XtraGrid.ViewOperationEventArgs e)
    Dim detailCloneView As GridView = TryCast(e.View, GridView)
    If detailCloneView.LevelName = "Order_Details" Then 
        detailCloneView.OptionsEditForm.CustomEditFormLayout = New AdvancedEditForm()
    End If 

repositoryItemTextEdit2.Mask.EditMask = "+1 (000) 000-00-00";
repositoryItemTextEdit2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
repositoryItemTextEdit1.Mask.UseMaskAsDisplayFormat = true; //optional 
gridView.Columns["Phone"].ColumnEdit = repositoryItemTextEdit2;

repositoryItemTextEdit2.Mask.EditMask = "+1 (000) 000-00-00" 
repositoryItemTextEdit2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric
repositoryItemTextEdit1.Mask.UseMaskAsDisplayFormat = True 'optional 
gridView.Columns("Phone").ColumnEdit = repositoryItemTextEdit2

private void GridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e) {
    GridView view = sender as GridView;
    if (view.FocusedColumn == colRequiredDate) {
        DateTime? requiredDate = e.Value as DateTime?;
        DateTime? orderDate = view.GetRowCellValue(view.FocusedRowHandle, colOrderDate) as DateTime?;
        if (requiredDate < orderDate) {
            e.Valid = false;
            e.ErrorText = "Required Date is earlier than the order date";
        }
    }
}

Private Sub GridView1_ValidatingEditor(ByVal sender As Object, ByVal e As DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs)
    Dim view As GridView = TryCast(sender, GridView)
    If view.FocusedColumn = colRequiredDate Then 
        Dim requiredDate? As Date = CType(e.Value, Date?)
        Dim orderDate? As Date = CType(view.GetRowCellValue(view.FocusedRowHandle, colOrderDate), Date?)
        If requiredDate < orderDate Then 
            e.Valid = False 
            e.ErrorText = "Required Date is earlier than the order date" 
        End If 
    End If 
End Sub 

private void gridView1_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) {
    GridView view = sender as GridView;
    float val = Convert.ToSingle(view.GetRowCellValue(e.RowHandle, gridColumn3)) * 
        Convert.ToInt16(view.GetRowCellValue(e.RowHandle, gridColumn4)) *
        (1 - Convert.ToSingle(view.GetRowCellValue(e.RowHandle, gridColumn5))); //Total Sum 
    if(val < 0) {
        e.ErrorText = string.Format("{0}\r\n", Properties.Resources.SubTotalGreaterEqual);
        e.Valid = false;
    }
}

Imports Microsoft.VisualBasic

Private Sub gridView1_ValidateRow(ByVal sender As Object, ByVal e As DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs)
    Dim view As GridView = TryCast(sender, GridView)
    Dim val As Single = Convert.ToSingle(view.GetRowCellValue(e.RowHandle, gridColumn3)) * Convert.ToInt16(view.GetRowCellValue(e.RowHandle, gridColumn4)) * (1 - Convert.ToSingle(view.GetRowCellValue(e.RowHandle, gridColumn5))) 'Total Sum 
    If val < 0 Then 
        e.ErrorText = String.Format("{0}" & ControlChars.CrLf, My.Resources.SubTotalGreaterEqual)
        e.Valid = False 
    End If 
End Sub