Display updated/added/deleted record in DataGridView on Refresh Button Click.

Question

1.00/5 (1 vote)

See more:

We want to refresh datagridview (displaying on screen) as soon as user makes any changes to the database table (binded with that datagridview) by clicking a Refresh button after any of above said operations.

How to do this?

Posted 16-May-11 20:43pm

sk saini

Updated 16-May-11 21:56pm

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 17-May-11 3:56am

Edited for Readability.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Programm3r · Answer 1 · 2011-05-16T20:50:00

Solution 1

Hi,

Please refer to the following post: How to insert, update, delete using DataGrid .. The post describes how to go about performing the actions you require.

Kind regards,

Posted 16-May-11 20:50pm

Programm3r

sk saini · Answer 2 · 2011-05-16T21:24:00

Solution 2

Thanks for your reply but actually my requirement is only to refresh DataGridView on each database table's change through btnClick() event.

Posted 16-May-11 21:24pm

sk saini

Comments

Programm3r 17-May-11 4:15am

The datagridview is bound to a local snapshot copy of the records in the database(not the database iteself), these are what is stored in the dataset.

However when your form updates the database, it doesnt automatically update the local snapshot copy of the records(dataset).

In order to do this you would need to repopulate the dataset by re-executing the Fill method to repopulate the dataset with the newly updated database records.

parmar_punit 17-May-11 5:20am

Do this...
Just Fire a query and Bind your GridView in the method of Refresh button's click as you bound your gridview in FormLoad...

Wayne Gaylard · Answer 3 · 2011-05-16T22:17:00

What you need to do is create a Refresh method that updates your Data Source and then rebinds to the DataGrid.
Here is an outline of how I would go about it

C#

public partial class MainWindow : Window
    {
        private List<yourItems> listItems;
        public MainWindow()
        {
            InitializeComponent();
            listItems = new List<yourItems>();
            Refresh();
        }
        private void Refresh()
        {
            listItems = DataAccess.GetData();
            DataGridView1.DataSource = listItems;
        }
        private void button1_click(object sender, EventArgs e)
        {
            Refresh();
        }
}

Hope this helps