Re-Use SqlCeResultSet troubles when binding to a DataGrid

[TWischmeier]

Hi,

I try to rewrite our application to make use of SqlCeResultSet instead
of DataTable. I try to reuse SqlCeResultSet objects as much as
possible. I have the following problem:

I have a result set which I use for searching. Basically, the user can
specify some search parameters. When those parameters have changed, I
invoke the following method:

rsCommand.ExecuteResultSet(resultSetOptions, existingResultSet);

I verified that the existingResultSet got updated properly - it just
showed the filtered rows. But I have trouble with displaying it. If I
bind it to a DataGrid once, I could not manage to get the DataGrid
updated after doing

rsCommand.ExecuteResultSet(resultSetOptions, existingResultSet);

again. I also tried

dataGrid.DataSource = null;
dataGrid.Datasource = existingResultSet;

but the DataGrid would still display the old rows (and only those I
already saw - the remaining rows will display (null)).

What am I doing wrong?

Best Regards,
Tim Wischmeier