I have an app that displays the contents of a dataset in a datagrid after a sub routine is called on it. The subroutine is called by clicking a button. The first time the button is clicked the data displays correctly in the data grid. After subsequent clicks, the data is changed in the dataset but the old results continue to show up in the data grid. Any idea on how I can remedy this?

Try clearing the datagrid using:

[DataGridName].DataSource = Nothing

Then add the new data back in.

J

WHen the data changes on the backed for the dataset, you need to rebind it.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Neither of these worked. It is rather odd. If I set it to a specific table in the dataset it works just fine. When I set it to the dataset as a whole it will refresh every table but the one that was last viewed before new data was brought in. I tried playing around with the data member property didn't seem to make a difference either.

Yes, you need to disconnect the dataset and rebind it to the control. and then refresh it.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee