Can a DataSet tell if tables in the SQL database have been updated?
I've got a client-server app that hooks up to a SQL Server 2000 database. So far everything works well but this application is not the only user of the database. We have an Access front-end that also hooks up to these tables. (The .Net application is replacing another application that goes to the same tables and will eventually also replace the access front-end but that's at least a year off)
My server application has a DataSet that mirrors the SQL tables. This way I have local copy of the table data I can work with programatically (and more quickly) and send updates to the SQL tables as necessary. This arrangement works well but I'm concerned about how to tell if the Access front-end has changed any of the SQL tables since I did the DataSet.Fill.
Is there any way for me to tell through the SQLDataAdapter whether the target SQL database has changed since the last time I've connected to it? I assume that this would have to be SQLServer-driven but I don't know how that would work.
Alternately, I could just do a Fill of the potentially affected tables but that will, hurt my latency.
Any ideas?
