Tukukkk

BindingSource is the only way without going for a 3rd party ORM, it may seem long winded at first but the benefits of one update method on the BindingSource are so helpful.

If your source is say for example a list of user strings

List<string> users = GetUsers();

BindingSource source = new BindingSource();

source.DataSource = users

dataGridView1.Datasource = source;

then when your done editing just update your data object whether that be a DataTable or List of user strings like here and ResetBindings on the BindingSource;

users = GetUsers(); //Update your data object

source.ResetBindings(false);

Rebind your DatagridView to the source.

DataGridView dg1 = new DataGridView();

dg1.DataSource = src1;



// Update Data in src1



dg1.DataSource = null;

dg1.DataSource = src1;

I don't know if this has really been solved or not... but by looking at all the other answers, nothing seems quite clear. The best way I found to do this is to put the same code, that was used to populate your datagridview into a method and pass it your form's datagridview, as so:

public void ConnectAndPopulateDataGridView(DataGridView dataGridView)

{ }

The code within the method is the exact same as the code used to populate the datagirdview originally, except for the datagridview name changing to whatever you called it in your method.

Now this method is called in your parent form.

The child form is launched via a .ShowDialog() then the method is called after so that it is called right after the child for is closed... as so:

ChildForm.ShowDialog();



ConnectAndPopulateDataGridView(dataGridView1);

You can use the DataGridView refresh method. But... in a lot of cases you have to refresh the DataGridView from methods running on a different thread than the one where the DataGridView is running. In order to do that you should implement the following method and call it rather than directly typing DataGridView.Refresh():

    private void RefreshGridView()

    {

        if (dataGridView1.InvokeRequired)

        {

            dataGridView1.Invoke((MethodInvoker)delegate ()

            {

                RefreshGridView();

            });

        }

        else

            dataGridView1.Refresh();

    }  

You just need to redefine the DataSource. So if you have for example DataGridView's DataSource that contains a, b, i c:

DataGridView.DataSource = a, b, c

And suddenly you update the DataSource so you have just a and b, you would need to redefine your DataSource:

DataGridView.DataSource = a, b

I hope you find this useful.

Thank you.

You can use SqlDataAdapter to update the DataGridView

     using (SqlConnection conn = new SqlConnection(connectionString))

        {

            using (SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM Table", conn))

            {

               DataTable dt = new DataTable();

                 ad.Fill(dt);

               dataGridView1.DataSource = dt;

            }

        }