CODEWITHSUNDEEP
c#datagridviewmaster-detailundo
Michael Bishop
Michael Bishop

Reputation: 4420

How do I make a DataGridView immediately commit edits?

I have a master-detail layout with a section of popup menus (the Details) and a section with a DataGridView which holds the rows.

The popup-menu state is updated when the selected row in the DataGridView changes and the state in the DGV's selected row should update when the popup-menu changes.

All of this works except the row in the DataGridView doesn't immediately update when I change the value of the popup-menu. I have to select a different row in order to see my edits.

I'm assuming this is because the edit hasn't been committed until the selection changes.

My question is: How do I make the change to the popup become immediately reflected in the DataGridView?

I have experimented with calling EndEdit() in the SelectionChangeCommitted handler for the popup-menu, but this has no effect. I'm interested in a technique that would allow me to create a DataGridView that would behave as if there were no Undo mechanism to begin with. Ideally the solution would be generic and transplantable to other projects.

Upvotes: 4

Views: 29051

Answers (6)

snipsnipsnip
snipsnipsnip

Reputation: 2585

It looks like existing answers work well with BindingSources. In my case, where a DataTable was directly used as the DataSource, they didn't work for some reason.

// Other answers didn't work in my setup...
private DataGridView dgv;

private Form1()
{
   var table = new DataTable();
   // ... fill the table ...
   dgv.DataSource = table;
}

After some hair-pulling, I got it work without adding BindingSource indirection:

// Add this event handler to the DataGridView
private void dgv_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
    dgv.BindingContext[dgv.DataSource].EndCurrentEdit();
}

private Form1()
{
   // Add the event handler above
   dgv.CellEndEdit += dgv_CellEndEdit;
}

Upvotes: 7

Srishanth Kumar
Srishanth Kumar

Reputation: 11

following will work

_dataGrid.EndEdit()

s fine once you set the value.

Upvotes: -1

Andrew
Andrew

Reputation: 11446

this works well for me:

private void CurrentCellDirtyStateChanged(object sender, EventArgs e)
{
    var dgw = (DataGridView) sender;
    dgw.CommitEdit(DataGridViewDataErrorContexts.Commit);
}

Upvotes: 4

Taher Rahgooy
Taher Rahgooy

Reputation: 6696

Use this extension method. It works for all columns types, not just ComboBoxes:

        public static void ChangeEditModeToOnPropertyChanged(this DataGridView gv)
        {
            gv.CurrentCellDirtyStateChanged += (sender, args) =>
            {
                gv.CommitEdit(DataGridViewDataErrorContexts.Commit);
                if (gv.CurrentCell == null)
                    return;
                if (gv.CurrentCell.EditType != typeof(DataGridViewTextBoxEditingControl))
                    return;
                gv.BeginEdit(false);
                var textBox = (TextBox)gv.EditingControl;
                textBox.SelectionStart = textBox.Text.Length;
            };
        }

This method commits every change just after the change is made.

When we have a text column, after typing a character, its value will commit to the DataSource and the editmode of the cell will end.

Therefore current cell should return to edit mode, and position of the cursor set to end of text in order to enable user to continue typing reminder of the text.

Upvotes: 3

Michael Bishop
Michael Bishop

Reputation: 4420

Here's what was going on. The answer was in the properties of the ComboBox instances. I needed to change their DataSourceUpdateMode from OnValidation to OnPropertyChanged. This makes sense. The DataGridView was very likely showing the current state of the data. It was just that the data hadn't been edited yet because focus had not left the ComboBox, validating the input.

Thanks to everyone for your responses.

Upvotes: 4

Tergiver
Tergiver

Reputation: 14517

Call the DataGridView.EndEdit method.

Upvotes: 0

Related Questions