Refresh button - Refreshing data grid view after inserting, deleting, updating

Question

I'm trying to create a refresh button to automatically refresh the data inside my datagridview after i have finish updating them.

However, my refresh button doesn't seem to work. The data displayed remains the same as the original one. It only gets updated after i manually end my windows app and rebuild it.

Here is my code:

 private void button_refresh_Click(object sender, EventArgs e)
        {
            this.acuzioSecureStore_DatabaseXDataSet.AcceptChanges();
        }

Please assist. thanks ^_^

related question that might help - http://stackoverflow.com/questions/11075031/refresh-datagridview-after-data-inserted-in-db-by-another-dialog — dutzu, Jan 17 '13 at 07:53

score 4 · Accepted Answer · edited Dec 07 '14 at 22:59

The easiest way to handle this is to use a Binding Source object.

If your loading information into your DataGridView from an Access Database then your most likely storing the Data in a Dataset or DataTable.

Create a Binding Source object, and once you have populated your DataTable/Dataset, set the datasource for your Binding Source to your DataTable. Then set the Datasource from the DataGridView as the Binding Source object.

Doing this ensures that any changes in your datagridview or reflected in the DataTable and vice Versa. If you reload data into your DataTable it will reflect in the Data Grid Automatically.

DataTable dt = new DataTable();

BindingSource bs = new BindingSource();

bs.DataSource = dt;

dataGridView1.DataSource= bs;

All changes will now happen automatically.

You willhave to raise it as a new question and show your code. — Derek, Mar 16 '17 at 15:15

score 0 · Answer 2 · answered Jan 26 '13 at 01:10

0

Hey the solution above is good but when the above code is executed,the table disappears and is not seen. And if I execute

        da.Fill(ds, "p");
        dataGridView1.DataSource = ds.Tables["p"];

then whole table is created again.

answered Jan 26 '13 at 01:10

DaitaSFDC

1

Can you specify which solution, and also what is the impact (good, bad, other) of the whole table is created again. – Lizz Jan 26 '13 at 01:28

score 0 · Answer 3 · answered May 23 '13 at 15:53

private void button_refresh_Click(object sender, EventArgs e)
        {
            SqlConnection con=new SqlConnection(@"");
            string query="select * from abc";
            SqlCommand cmd=new SqlCommand(query,con);
            SqlDataAdapter da=new SqlDataadapter(cmd);
            DataTable dt=new DataTable();
            da.Fill(dt);
            dataGridView1.DataSource=dt;
        }

score 0 · Answer 4 · answered Sep 15 '13 at 11:50

I had a datagridview, bound to a table in an Entity Framework database:

dataGridView1.DataSource = MyDatabase.MyTable;

It would never refresh despite two wasted days. I solved it with a simple workaround:

private void button_refresh_Click(object sender, EventArgs e) {
    dataGridView1.DataSource = MyDatabase.MyTable.Where(i =>(true));
}

This is an ugly workaround, and friend explained me how it works - if I do just dataGridView1.DataSource = database.table, it will cache the table and use the cached data forever. The fact that each time we create a new dummy query, prevents .net from caching it.

score 0 · Answer 5 · edited Feb 04 '15 at 14:29

0

Please try this, it worked for me and let me know if you have any better option.

private void button3_Click(object sender, EventArgs e)
{
    dataGridView1.Refresh();
}

edited Feb 04 '15 at 14:29

Bowdzone

3,827
11
39
52

answered Feb 04 '15 at 13:49

karthik

82
10

score 0 · Answer 6 · answered Jun 09 '17 at 08:43

0

you Can Bind dataGridView On PageLoad or UserControl Load Event and After chage in grid view Call the Load Event

like

this.ucUsers_Load(null, null); // Windows From C#

answered Jun 09 '17 at 08:43

user3098137

511
4
7

Refresh button - Refreshing data grid view after inserting, deleting, updating

6 Answers6

Linked

Related