I'm sure there are MANY ways of doing a "behind-the-scenes" update of the data in dataset, you know an update that happens to the data in the dataset but the user doesn't see he/her datagrid change much if any. I have an idea about how I CAN do it but I am wondering how I SHOULD do it. I'm sure there is a best-practices article out there somewhere but I can't find it. Has anyone found a a really great way that has worked for them, for multiple users? Anybody have any ideas?

I am a VB/C# .NET 2003 programmer using SQL Server 2000 databases, but I'm open to other languages and/or database architectures.

- Thanks in advace for any and all help, comments, ideas, on the matter.