New to Telerik UI for WinForms? Download free 30-day trial

Change the active editor depending on the cell value type.

Common case is to have a single column (for example a GridViewTextBoxColumn) with different values in the rows. Naturally the user will want to edit the respective values in appropriate editors. For example if you have a GridViewTextBoxColumn with tree rows where the first row has a DateTime value, the second has decimal value and the third has text value, it would be nice for the end user to edit the date in a date time editor, the decimal value in a numeric editor and the text in a text editor. This article is going to show how this behavior can be achieved in few easy steps.

First we can set up the grid with some columns and rows, this will allow us to observe the editor behavior later. Just drop a RadGridView in a blank form and then use the following code to initialize the grid. At the end, subscribe to the EditorRequired event, which is triggered when a cell needs an editor:


private void ChangeTheActiveEditorDependingOnTheCellValueType_Load(object sender, EventArgs e)
{
    GridViewTextBoxColumn gridViewTextBoxColumn1 = new GridViewTextBoxColumn();
    GridViewTextBoxColumn gridViewTextBoxColumn2 = new GridViewTextBoxColumn();
    gridViewTextBoxColumn1.HeaderText = "column1";
    gridViewTextBoxColumn1.Name = "column1";
    gridViewTextBoxColumn1.Width = 100;
    gridViewTextBoxColumn2.HeaderText = "column2";
    gridViewTextBoxColumn2.Name = "column2";
    gridViewTextBoxColumn2.Width = 150;
    this.radGridView1.MasterTemplate.Columns.AddRange(new GridViewDataColumn[]
    {
        gridViewTextBoxColumn1,
        gridViewTextBoxColumn2
    });
    this.radGridView1.Rows.Add("row 1", DateTime.Now.ToString());
    this.radGridView1.Rows.Add("row 2", "6");
    this.radGridView1.Rows.Add("row 3", "test");
    this.radGridView1.EditorRequired += radGridView1_EditorRequired;
}

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
    Dim gridViewTextBoxColumn1 As New GridViewTextBoxColumn()
    Dim gridViewTextBoxColumn2 As New GridViewTextBoxColumn()
    gridViewTextBoxColumn1.HeaderText = "column1"
    gridViewTextBoxColumn1.Name = "column1"
    gridViewTextBoxColumn1.Width = 100
    gridViewTextBoxColumn2.HeaderText = "column2"
    gridViewTextBoxColumn2.Name = "column2"
    gridViewTextBoxColumn2.Width = 150
    Me.RadGridView1.MasterTemplate.Columns.AddRange(New GridViewDataColumn() {gridViewTextBoxColumn1, gridViewTextBoxColumn2})
    Me.RadGridView1.Rows.Add("row 1", DateTime.Now.ToString())
    Me.RadGridView1.Rows.Add("row 2", "7")
    Me.RadGridView1.Rows.Add("row 3", "test")
    AddHandler RadGridView1.EditorRequired, AddressOf radGridView1_EditorRequired
End Sub

Now we just need to match the value with the appropriate type and show the corresponding editor. We can do that with the following EditorRequired event handler:

void radGridView1_EditorRequired(object sender, EditorRequiredEventArgs e)
{
    DateTime date;
    if (DateTime.TryParse(radGridView1.CurrentCell.Value.ToString(), out date))
    {
        e.EditorType = typeof(RadDateTimeEditor);
        return;
    }
    int i = 0;
    if (int.TryParse(radGridView1.CurrentCell.Value.ToString(), out i))
    {
        e.EditorType = typeof(GridSpinEditor);
        return;
    }
    if (radGridView1.CurrentCell.Value is string)
    {
        e.EditorType = typeof(RadTextBoxEditor);
        return;
    }
}

Private Sub radGridView1_EditorRequired(sender As Object, e As EditorRequiredEventArgs)
    Dim [date] As DateTime
    If DateTime.TryParse(RadGridView1.CurrentCell.Value.ToString(), [date]) Then
        e.EditorType = GetType(RadDateTimeEditor)
        Return
    End If
    Dim i As Integer = 0
    If Integer.TryParse(RadGridView1.CurrentCell.Value.ToString(), i) Then
        e.EditorType = GetType(GridSpinEditor)
        Return
    End If
    If TypeOf RadGridView1.CurrentCell.Value Is String Then
        e.EditorType = GetType(RadTextBoxEditor)
        Return
    End If
End Sub

The result is that the end user can edit the cells with the appropriate for their values editor:

gridview-editors-howto-change-the-active-editor-depending-on-the-cell-value-type 001

gridview-editors-howto-change-the-active-editor-depending-on-the-cell-value-type 002

See Also

In this article
Not finding the help you need? Improve this article