What I have is a system that has a single table in a sql dbase and the entire contents of this table are dumped into a dataset via sqldataadapter.fill.
Changes to this dataset can be sent back to the dbase fine using the sqldataadapter.update method without any problem as well.
Where I am having problems is in the case that a second user adds rows (or alters existing data) in the database, I cannot seem to get this updated data to syncronize with my client's dataset. I am obviously doing something wrong here and I cannot seem to find an example that shows this.
Ideally I would like to avoid clearing the dataset as the quantity of dat in the table is substantial. The table has a unique id column and a "datemask" column which indicates the last time a row was altered.
Can anyone please give me an example of how to do this? I have wasted a lot of time on something I am sure is very simple.
Thanks in advance for any help.