Hi

I'm building a distributed application using remoting in a small company.
The client side has a dataset (a local cache) which is bound to a third party
grid control. The server fires events to each of its clients with updates for
the dataset. I was wondering what the best way of merging the datatable from
the server with its collection of rows and the local dataset cache together
was.

The problem with the merge method is that if you update more than one row
the dataset will tell the bound gird that it has reset and should refresh its
list of data which can obviously cause problems when refreshing thousands and
regular, fairly quick updates.

At the moment when a datatable is received I’m queuing each of the data rows
to be updated and then calling a LoadDataRow method so that we only update
one row at a time.

We’ve had some strange instances of receiving the datatables fine, but the
cache doesn’t seem to be updating correctly after the LoadDataRow method is
called.

So I guess my question is does anyone or could anyone think of a better
solution? I’m guessing not but you never know and does anyone know of any
pitfalls in using this method?

Thanks for anytime that anyone puts into this post.

Iterating through selects - what is the best approach?
How to Insert a whole dataset into database
Connection string information
Memory usage increases with ADO.NET v2.0 RTM
DataSet to Access Database