Howdy, Stranger!

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

Categories

Updating dataset from sql dbase

Wizard_TPGWizard_TPG Member Posts: 1
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.