Export (0) Print
Expand All

SqlCommandBuilder Members

Automatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited.

The SqlCommandBuilder type exposes the following members.

  NameDescription
Public method Supported by the .NET Compact Framework SqlCommandBuilder Overloaded. Initializes a new instance of the SqlCommandBuilder class.
Top

  NameDescription
Protected method ApplyParameterInfo Allows the provider implementation of the DbCommandBuilder class to handle additional parameter properties. (Inherited from DbCommandBuilder.)
Public method CreateObjRef Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public method Static member Supported by the .NET Compact Framework DeriveParameters Retrieves parameter information from the stored procedure specified in the SqlCommand and populates the Parameters collection of the specified SqlCommand object.
Public method Supported by the .NET Compact Framework Dispose Overloaded.
Public method Supported by the .NET Compact Framework Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Supported by the .NET Compact Framework Finalize Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.)
Public method Supported by the .NET Compact Framework GetDeleteCommand Overloaded. Gets the automatically generated SqlCommand object required to perform deletions on the database.
Public method Supported by the .NET Compact Framework GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetInsertCommand Overloaded.
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected method GetParameterName Infrastructure. Overloaded. Returns the name of the specified parameter.
Protected method GetParameterPlaceholder Infrastructure. Returns the placeholder for the parameter in the associated SQL statement. (Inherited from DbCommandBuilder.)
Protected method GetSchemaTable Returns the schema table for the DbCommandBuilder. (Inherited from DbCommandBuilder.)
Protected method GetService Returns an object that represents a service provided by the Component or by its Container. (Inherited from Component.)
Public method Supported by the .NET Compact Framework GetType Gets the type of the current instance. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetUpdateCommand Overloaded. Gets the automatically generated SqlCommand object required to perform updates on the database.
Protected method InitializeCommand Resets the CommandTimeout, Transaction, CommandType, and UpdateRowSource properties on the DbCommand. (Inherited from DbCommandBuilder.)
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected method Supported by the .NET Compact Framework MemberwiseClone Overloaded.
Public method QuoteIdentifier Given an unquoted identifier in the correct catalog case, returns the correct quoted form of that identifier. This includes correctly escaping any embedded quotes in the identifier. (Overrides DbCommandBuilder.QuoteIdentifier(String).)
Public method Supported by the .NET Compact Framework RefreshSchema Clears the commands associated with this DbCommandBuilder. (Inherited from DbCommandBuilder.)

In .NET Compact Framework 3.5, this member is RefreshSchema().
Protected method RowUpdatingHandler Adds an event handler for the RowUpdating event. (Inherited from DbCommandBuilder.)
Protected method SetRowUpdatingHandler Registers the DbCommandBuilder to handle the RowUpdating event for a DbDataAdapter. (Inherited from DbCommandBuilder.)
Public method ToString Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.)
Public method UnquoteIdentifier Given a quoted identifier, returns the correct unquoted form of that identifier. This includes correctly unescaping any embedded quotes in the identifier. (Overrides DbCommandBuilder.UnquoteIdentifier(String).)
Top

  NameDescription
Protected property CanRaiseEvents Gets a value indicating whether the component can raise an event. (Inherited from Component.)
Public property CatalogLocation Sets or gets the CatalogLocation for an instance of the SqlCommandBuilder class. (Overrides DbCommandBuilder.CatalogLocation.)
Public property CatalogSeparator Sets or gets a string used as the catalog separator for an instance of the SqlCommandBuilder class. (Overrides DbCommandBuilder.CatalogSeparator.)
Public property ConflictOption Specifies which ConflictOption is to be used by the DbCommandBuilder. (Inherited from DbCommandBuilder.)
Public property Container Gets the IContainer that contains the Component. (Inherited from Component.)
Public property Supported by the .NET Compact Framework DataAdapter Gets or sets a SqlDataAdapter object for which Transact-SQL statements are automatically generated.
Protected property DesignMode Gets a value that indicates whether the Component is currently in design mode. (Inherited from Component.)
Protected property Supported by the .NET Compact Framework Events Gets the list of event handlers that are attached to this Component. (Inherited from Component.)
Public property Supported by the .NET Compact Framework QuotePrefix Gets or sets the starting character or characters to use when specifying SQL Server database objects, such as tables or columns, whose names contain characters such as spaces or reserved tokens. (Overrides DbCommandBuilder.QuotePrefix.)
Public property Supported by the .NET Compact Framework QuoteSuffix Gets or sets the ending character or characters to use when specifying SQL Server database objects, such as tables or columns, whose names contain characters such as spaces or reserved tokens. (Overrides DbCommandBuilder.QuoteSuffix.)
Public property SchemaSeparator Gets or sets the character to be used for the separator between the schema identifier and any other identifiers. (Overrides DbCommandBuilder.SchemaSeparator.)
Public property SetAllValues Specifies whether all column values in an update statement are included or only changed ones. (Inherited from DbCommandBuilder.)
Public property Supported by the .NET Compact Framework Site Gets or sets the ISite of the Component. (Inherited from Component.)
Top

  NameDescription
Public event Supported by the .NET Compact Framework Disposed Occurs when the component is disposed by a call to the Dispose method. (Inherited from Component.)
Top

Community Additions

ADD
Show:
© 2014 Microsoft