Take a look at OleDbCommandBuilder class

>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.