Update datagrid view with updated data

Question

Hello,

I've a datagridview. I read an xml file and bind the data to the gridview. I change the xml and save it in another form. So i reread the xml file and i bind it to the gridview. The datatable is getting the updated values. But the grid is not getting updated till i close and open the application again. How to do it?

Thank you.

Regards, Raghavendra

#1

Is there a Databind() or Rebind() for DataGridView? I set the datasource like this -

dvMoviesList.DataSource = dtMovies;

If i add any new row to the dtMovies table and set the datasource again, it is getting reflected. But if i edit the values of any of the existing rows and re assign the datasource it is not getting reflected till i close and open the application again. Any ideas?

Thank you.

Answer 1

Are you calling DataBind() after you update the DataTable?

Answer 2

hi, please try this, dvMoviesList.Refresh();

Answer 3

It seems like a previously asked question:
http://stackoverflow.com/questions/253843/simple-datagridview-refresh-question

Look at the answer given by Alan, maybe it is the solution you are searching for.

Regards
Thomas

Answer 4

I think you need to place a BindingSource in between the DataGridView and DataTable.

DataGridView _dgv = new DataGridView();
BindingSource _bs = new BindingSource();
DataTable _dt = new DataTable();
.
.
.
_dgv.DataSource = _bs;
_bs.DataSource = _dt;

Now whenever _dt gets updated, the BindingSource should take care of refreshing the DataGridView and you shouldn't have to worry about resetting any DataSource property. The DataSource properties can be set in the InitializeComponent() method (the designer), the Form's constructor, or Form.Load event handler.

Answer 5

All you need is to Databind your datasource just like this

ArrayList list = new ArrayList();
list = YourXMLContent.GetItems(); 
GridView1.datasource = list;  // you can use you DataTable instead of list
GridView1.update();
Gridview1.invalidate();

its all.

Answer 6

I am sure what I am about to suggest is not the right way but I ran into the same issue and being an ASP.NET developer mostly and not having done much work in winforms the only solution I found was to set the datasource to NULL then rebind the data.

Example: this.dataGridView.DataSource = null; this.dataGridView.DataSource = myDataSource;

Going to verify the solution recommened by Nasser as the solution I have just does not seem right even though it works.