This really depends on whether you are talking ASP.NET or WIndows Forms. For
Windows forms, you can cache the DataSet on the client and set up your own
updater on a different thread. This will, in most instances, keep you in sync.

With ASP.NET, it gets trickier, as ASP.NET is completely disconnected and
also paints in HTML, so the direct connection to data is not there. You can
cache the DataSet on the server, which will speed things up somewhat, but you
will still have to round trip.

You can cut some of this out by using XML and only rebinding part of the
form, but this will make a less maintainable system.

You mean you're adding records directly to the database by executing some
query and refilling DataSet to show it?

If so, that's not the right way to do it. Instead add record(s) to the
DataSet and run DataAdapter.Update() as soon as you ready to update the
database.

This way you can do a bulk update and new/changed records will be shown in
the grid instantly.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactfra
mework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).