GetInsertCommand() Method

Gets the TdCommand object with the required CommandText and Parameters properties to insert a row.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Overloads Shadows Function GetInsertCommand() As TdCommand

'Usage
 
Dim instance As TdCommandBuilder
Dim value As TdCommand
 
value = instance.GetInsertCommand()

public new TdCommand GetInsertCommand()

public:
new TdCommand^ GetInsertCommand();

Return Value

A TdCommand object with required CommandText property and Parameters collection properly set for a insert operation.

Exceptions

Exception	Description
System.InvalidOperationException	The DataAdapter property is not set, SelectCommand of the associated TdDataAdapter is not set or No TdConnection is associated with DataAdapter.SelectCommand
System.ObjectDisposedException	The TdCommandBuilder is closed / disposed.

Remarks

The invocation of GetInsertCommand method can result in one or more calls to the Teradata Database to retrieve metadata (Column and Table information). The metadata is cached in order to minimize roundtrips to the Advanced SQL Engine. The cache is purged only when the DataAdapter property is set or the Refresh method is called

The TdCommand object returned will contain the INSERT statement required to insert a row into the table specified in DataAdapter.SelectCommand.CommandText property. The DataAdapter.SelectCommand.CommandText must be a single table SELECT statement. The TdCommandBuilder cannot generate a INSERT statement for a SELECT statement that contains implicit or explicit Joins

Requirements

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

Reference

TdCommandBuilder Class
TdCommandBuilder Members
Overload List