Syed Sami Naushahi
1. Open the DataSet in the designer.
2. Click on the adapter portion of the relevant table. For example in my case I clicked on DoctorTableAdopter.
3. The properties window will show the UpdateCommand and DeleteCommand for this adopter.
4. Expand Update and Delete commands by clicking the + sign on their left. This would show the CommandText property for these commands.
5. Click on the value entered against CommandText. It will show you the SQL statement for that command. Edit its WHERE clause and remove all other columns except the columns included in your primary key. For example in my case a rather lengthy WHERE clause (which was trying to compare more than a dozen columns) was modified to
WHERE (Doctor_ID = @Original_Doctor_ID).