Synopsis
SqlCommand updateCommand = DataAdapter.UpdateCommand;
DataAdapter.UpdateCommand = updateCommand;
Gets or sets the command, either a SQL statement or a stored
procedure, that updates modified DataSet
records
in the data source when the Update( )
method is
called.
Example
See the Example for the DeleteCommand
property in
this chapter.
Note
If the UpdateCommand
property
isn’t set, and the DataSet
has a
primary key, the UpdateCommand
can be generated
automatically using the CommandBuilder
after
specifying the SelectCommand
property.