Send feedback on this topic.
Teradata.Client.Provider
UpdateCommand Property



Teradata.Client.Provider Namespace > TdDataAdapter Class : UpdateCommand Property
Gets or sets a TdCommand used to update a SQL table row corresponding to a row in a DataTable.
Syntax
'Declaration
 
Public Shadows Property UpdateCommand As TdCommand
'Usage
 
Dim instance As TdDataAdapter
Dim value As TdCommand
 
instance.UpdateCommand = value
 
value = instance.UpdateCommand
public new TdCommand UpdateCommand {get; set;}
public:
new property TdCommand^ UpdateCommand {
   TdCommand^ get();
   void set (    TdCommand^ value);
}

Property Value

Spedifies TdCommand used to update a row in a SQL table corresponding to a DataRow in a DataTable. The default value is null.
Remarks

The UpdateCommand property updates a row in the Teradata database. The data adapter does not modify the TdCommand object (UpdateCommand), but it maps the DataRow to TdCommand.Parameters collection, and executes the resulting command. See TdParameter.SourceColumn for additional information on how the columns in the DataTable and therefore DataRow are mapped to the parameters.

It is your responsibility to map the columns in DataTable to the parameters. Alternatively, the TdCommandBuilder can dynamically generate the TdCommand used to update a row in a SQL table.

When you set the UpdateCommand property, the TdCommand object passed in is not cloned but rather a reference to the object is maintained by the TdDataAdapter.

Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

See Also

Reference

TdDataAdapter Class
TdDataAdapter Members