To repeat : The Update command is constructed based on the Select command

You're selecting everything so it's updating everything.

>The SQLCommand I am passing is very simple
>
>select * from myTable where PK = @PK
>
>However, the UpdateCommand I am getting is
>
>update myTable set PkColumn = @PK, OtherColumns = ...
>WHERE PkColumn = @OriginalPk and OtherColumns = @OriginalValue
>-----------------------------------------------------------------
>
>I actually want to update only certain columns (not all of them) and only based on the PK column. I don't see in the docs how can I influence the Update command the SqlCommandBuilder is building.
>
>
>>Read the docs. The Update command is constructed based on the Select command used by the DataAdapter.
>>
>>Where do you see it updating fields in the 'WHERE' clause (or the PK) if these are not included in the select statement ?
>>
>>
>>
>>>>Hi everybody,
>>>>
>>>>I am wondering if you're using SqlCommandBuilder class and is there a way to get it generate normal UpdateCommand and not update command that even updates PK column and uses all columns in the where clause?
>>>>
>>>>I have this method at present
>>>>
>>>>

>>>>  protected Boolean ProcessDataTable(SqlCommand toSqlCommand, Boolean generateCommands = false)
>>>>        {
>>>>            Boolean results = false;
>>>>
>>>>            try
>>>>            {
>>>>                this.table = new DataTable();
>>>>                this.adapter = new SqlDataAdapter(toSqlCommand);
>>>>                this.adapter.SelectCommand = toSqlCommand;
>>>>                this.adapter.Fill(this.table);
>>>>                if (generateCommands)
>>>>                {
>>>>                    SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
>>>>                    adapter.UpdateCommand = builder.GetUpdateCommand(true);
>>>>                }
>>>>                results = true;
>>>>            }
>>>>            catch (Exception ex)
>>>>            {
>>>>                results = false;
>>>>                Logging.LogFormat(2, ex.Message);  // at least log the problem
>>>>            }
>>>>
>>>>            return results;
>>>>        }

>>>>
>>>>The idea is to simulate VFP TableUpdate, so I can set various columns values and then call a method that will automatically update my table. I got this suggestion in C# forum at MSDN, but the UpdateCommand generated is so ugly, that I am wondering if there can be any other approach.
>>>>
>>>>Thanks in advance.
>>>
>>>So, no suggestions? Nobody uses the same approach?
>>>
>>>Thanks in advance.