I've made a Dataset and within the dataset I've managed to connect to a foxpro table entitled c:\temp\payroll.dbf via a connection string.

Then I made a TableAdapter called PayrollAdapter.

I can display the data without any problems using the SelectCommand method of the PayrollAdapter class.

I have tried using the UpdateCommand method of the PayrollAdapter class to update the records that change. But I do not know how to change only the records that were changed. In the query builder I've managed to include commands like :

UPDATE Payroll
SET `branch` = "ABC"

but all this does is change every 'branch' field in the payroll.dbf to "ABC"

How do i change only the record the user modified in the form?

The query builder doesnt have intellisense :)


Dave.