Refresh datagridview win forms after updating the database from a child form

Question

how to refresh datagridview after making changes on the database from another form, after closing child form i tried to refresh the datagridview with click event but it's not working, do i have to use dataset ?

            //create an OleDbDataAdapter to execute the query
            dAdapter = new OleDbDataAdapter(gQuery, connString);

            //create a command builder
            cBuilder = new OleDbCommandBuilder(dAdapter);

            //create a DataTable to hold the query results
            dTable = new DataTable();

            //fill the DataTable
            dAdapter.Fill(dTable);


            //BindingSource to sync DataTable and DataGridView
            bSource = new BindingSource();

            //set the BindingSource DataSource
            bSource.DataSource = dTable;


            //set the DataGridView DataSource
            dataGridView1.DataSource = bSource;

    private void button_Refresh_Click(object sender, EventArgs e)
    {

        dataGridView1.DataSource = bSource;
        dataGridView1.Refresh();


    }

Help me, please thanks in advance

Solution 1

Add

dataGridView1.Update();

It will solve your problem.

Solution 2

When you link your database with "DataSource" in DataGridView properties, IDE automatically adds BindingSource and TableAdapter to your form.

If database is updated and you want to refresh DataGridView, call this:

this.<table name>TableAdapter.Fill(this.<DB name>DataSet.<table name>);

Where <table name> is name of your table (for example Users) and <DB name> is name of your database (for example MyDB).

this.UsersTableAdapter.Fill(this.MyDBDataSet.Users);

Comments

[usefulBee]

Great answer. I have been looking for this. Thanks!