A way to generate single-table SQL statements that reconcile changes made to a DataSet with the data in the associated database.
Visual Basic syntax C# syntax Base classes MembersAll members of SACommandBuilder class, including all inherited members.
| Name | Description |
|---|---|
| Initializes an SACommandBuilder object. | |
|
|
Allows the provider implementation of the ![[external link]](gif/external.gif) System.Data.Common.DbCommandBuilder class to handle additional parameter properties.
|
| Populates the Parameters collection of the specified SACommand object. | |
|
|
Releases the unmanaged resources used by the System.Data.Common.DbCommandBuilder and optionally releases the managed resources.
|
| Returns the generated SACommand object that performs DELETE operations on the database when SADataAdapter.Update is called. | |
| Returns the generated SACommand object that performs INSERT operations on the database when an Update is called. | |
|
|
Returns the name of the specified parameter in the format of @p#. |
|
|
Returns the placeholder for the parameter in the associated SQL statement. |
|
|
Returns the schema table for the System.Data.Common.DbCommandBuilder.
|
| Returns the generated SACommand object that performs UPDATE operations on the database when an Update is called. | |
|
|
Resets the System.Data.Common.DbCommand.CommandTimeout, System.Data.Common.DbCommand.Transaction, System.Data.Common.DbCommand.CommandType, and System.Data.UpdateRowSource properties on the System.Data.Common.DbCommand.
|
| Returns the correct quoted form of an unquoted identifier, including properly escaping any embedded quotes in the identifier. | |
|
|
Clears the commands associated with this System.Data.Common.DbCommandBuilder.
|
|
|
Adds an event handler for the System.Data.OleDb.OleDbDataAdapter.RowUpdating event.
|
|
|
Registers the System.Data.Common.DbCommandBuilder to handle the System.Data.OleDb.OleDbDataAdapter.RowUpdating event for a System.Data.Common.DbDataAdapter.
|
| Returns the correct unquoted form of a quoted identifier, including properly un-escaping any embedded quotes in the identifier. | |
|
|
Sets or gets the System.Data.Common.CatalogLocation for an instance of the System.Data.Common.DbCommandBuilder class.
|
|
|
Sets or gets a string used as the catalog separator for an instance of the System.Data.Common.DbCommandBuilder class.
|
|
|
Specifies which System.Data.ConflictOption is to be used by the System.Data.Common.DbCommandBuilder.
|
| Specifies the SADataAdapter for which to generate statements. | |
|
|
Gets or sets the beginning character or characters to use when specifying database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens. |
|
|
Gets or sets the beginning character or characters to use when specifying database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens. |
|
|
Gets or sets the character to be used for the separator between the schema identifier and any other identifiers. |
|
|
Specifies whether all column values in an update statement are included or only changed ones. |
SACommandBuilder constructor
DeriveParameters method
GetDeleteCommand method
GetInsertCommand method
GetUpdateCommand method
QuoteIdentifier method
UnquoteIdentifier method
DataAdapter property
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |