>>>>Try reading again.
>>>>"To generate INSERT, UPDATE, or DELETE statements, the SqlCommandBuilder uses the SelectCommand property to retrieve a required set of metadata automatically. If you change the SelectCommand after the metadata has been retrieved, such as after the first update, you should call the RefreshSchema method to update the metadata."
>>>
>>>I did read this line. However, it doesn't explain why will it use all columns to generate WHERE clause.
>>
>>Dunno, didn't write it. Looks like if's meant to cope with NULL values.
>>
>>> What exactly does required metadata mean?
>>
>>Info on the fields in the Select command.
>>
>>> Why it can not see that PK column I retrieve is a PK column?
>>
>>I thought it did. If I include the PK in the Select command it doesn't generate an update for it in the Update command......
>
>If you use select * from myTable where Pk = @Pk, will your update command include PK column?

No