Dynamically updating the data source

[Christina]

I am trying to change the data source of the data bound grid at run-time, but I can't figure out how. As the code sits right now, instead of clearing and displaying the new data, the grid is appending data every time I change the source.

In the User's Guide I read about the virtual grid - should I use this instead?

Thanks for your help!

[Administrator]

Are you calling dataAdapter.Fill repeatedly?

If so, this will append the data to the existing data which sort of sounds like what you are seeing. So, make sure you call something like DataTable.Clear before you load the data again into the same table.

[Christina]

Ok, I'm an idiot. That was the problem.