DGV Cell tools event handler - can't change cell.Value

[itg-assistant]

Tiago Freitas Leal asked 2016-08-26 14:40:37 UTC

On my DGV, I have a Tool in a TextBox column. The tool has a proper name (tool.Name = "clear").

The event handler fetches the cell

var cell = ((DataGridView)sender).Rows[e.RowIndex].Cells[e.ColumnIndex];

and set its value to empty

cell.Value = string.Empty;

The debugger shows that each step does what it's supposed to do but the fact is the DGV cell shows the same content (if I set it to "Abc", after running the tool it shows "Abc" all the same)

Sample attached

[itg-assistant]

Luca answered 2016-08-26 15:15:22 UTC

Hi Tiago,

It changes the value of the cell, but you don't see it because the editor is in front of it. Try to change the editor:

((DataGridView)sender).EditingControl.Text = "";

It's the same in WinForms. Cell.Value is always the stored value. Cell.EditedFormattedValue is the value in the editor - if in edit mode - or the cell, but it's read-only.

Best,

Luca

[itg-assistant]

Tiago Freitas Leal answered 2016-08-26 15:25:10 UTC

Changed the handler to

private void dataGridView1_CellToolClick(object sender, DataGridViewToolClickEventArgs e)
{
    var cell = ((DataGridView)sender).Rows[e.RowIndex].Cells[e.ColumnIndex];
    cell.Value = string.Empty;

    ((DataGridView)sender).EditingControl.Text = cell.Value.ToString();

}

and now it works.