GetUpdateCommand() Method

Gets the TdCommand object with the required CommandText and parameters properties to update a row.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Overloads Shadows Function GetUpdateCommand() As TdCommand

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

public new TdCommand GetUpdateCommand()

public:
new TdCommand^ GetUpdateCommand();

Return Value

Returns a TdCommand object with required CommandText property and parameters collection properly set for a update 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 GetUpdateCommand method can result in one or more calls to 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 UPDATE statement required to update a row in the table specified in DataAdapter.SelectCommand.CommandText property. The DataAdapter.SelectCommand.CommandText must be a single table SELECT statement. The TdCommandBuilder cannot generate an UPDATE 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