InsertCommand Property

Gets or sets a TdCommand used to insert a row into a Teradata Table corresponding to a row in a DataTable.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Shadows Property InsertCommand As TdCommand

'Usage
 
Dim instance As TdDataAdapter
Dim value As TdCommand
 
instance.InsertCommand = value
 
value = instance.InsertCommand

public new TdCommand InsertCommand {get; set;}

public:
new property TdCommand^ InsertCommand {
   TdCommand^ get();
   void set (    TdCommand^ value);
}

Property Value

Specifies a TdCommand object used to insert a row into the Advanced SQL Engine table which corresponds to the inserted row in the DataTable. The default value is null.

Remarks

The InsertCommand property is used to insert a row into the Teradata Database. The data adapter does not modify the TdCommand object (InsertCommand) but it maps the DataRow to the TdCommand.Parameters collection and executes the resulting command. See TdParameter. SourceColumn for additional information on how the columns in the DataTable and how the DataRow are mapped to the parameters.

It is your responsibility to map the columns in DataTable to the parameters. Alternatively, TdCommandBuilder is used to dynamically generate the TdCommand used to insert a row into the Advanced SQL Engine.

When the InsertCommand property is set, the passed in TdCommand object 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

Reference

TdDataAdapter Class
TdDataAdapter Members