Updating dataset from sql dbase

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.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!