[About] Version=1.0 Author=Nic Mail=support@hiasm.com [Type] Class=Element Inherit=DbCommandBuilder Interfaces=Component,MarshalByRefObject,Object,SqlCommandBuilder Info=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. [Property] Name=Sets the name of the component. ARG(string)|2| Constructor=Sets the Constructor of the SqlCommandBuilder class. ARG(enum)|14|0|Constructor,Constructor2 @DataAdapter=Sets a SqlDataAdapter object for which Transact-SQL statements are automatically generated. ARG(SqlDataAdapter)|20|(empty)|SqlDataAdapter [Methods] *doCatalogLocation=Sets the CatalogLocation for an instance of the SqlCommandBuilder class. ARG(CatalogLocation)|1|0 *doCatalogSeparator=Sets a string used as the catalog separator for an instance of the SqlCommandBuilder class. ARG(string)|1|0 *doConstructor=Initializes a new instance of the SqlCommandBuilder class. ARG()|1|0 *doConstructor2=Initializes a new instance of the SqlCommandBuilder class with the associated SqlDataAdapter object. ARG(SqlDataAdapter adapter)|1|0 *doDeriveParameters=Retrieves parameter information from the stored procedure specified in the SqlCommand and populates the Parameters collection of the specified SqlCommand object. ARG(SqlCommand command)|1|0 *doGetDeleteCommand2=Gets the automatically generated SqlCommand object that is required to perform deletions on the database. ARG(bool useColumnsForParameterNames)|1|0 *doGetInsertCommand2=Gets the automatically generated SqlCommand object that is required to perform insertions on the database. ARG(bool useColumnsForParameterNames)|1|0 *doGetUpdateCommand2=Gets the automatically generated SqlCommand object required to perform updates on the database. ARG(bool useColumnsForParameterNames)|1|0 *doQuoteIdentifier=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. ARG(string unquotedIdentifier)|1|0 *doQuotePrefix=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. ARG(string)|1|0 *doQuoteSuffix=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. ARG(string)|1|0 *doSchemaSeparator=Sets the character to be used for the separator between the schema identifier and any other identifiers. ARG(string)|1|0 *doUnquoteIdentifier=Given a quoted identifier, returns the correct unquoted form of that identifier. This includes correctly unescaping any embedded quotes in the identifier. ARG(string quotedIdentifier)|1|0 *onGetDeleteCommand=Occurs after invoke the method doGetDeleteCommand and returns the result. ARG(SqlCommand)|2|0 *onGetInsertCommand=Occurs after invoke the method doGetInsertCommand and returns the result. ARG(SqlCommand)|2|0 *onGetUpdateCommand=Occurs after invoke the method doGetUpdateCommand and returns the result. ARG(SqlCommand)|2|0 *onQuoteIdentifier=Occurs after invoke the method doQuoteIdentifier and returns the result. ARG(string)|2|2 *onUnquoteIdentifier=Occurs after invoke the method doUnquoteIdentifier and returns the result. ARG(string)|2|2 *CatalogLocation=Sets or gets the CatalogLocation for an instance of the SqlCommandBuilder class. ARG(CatalogLocation)|3|0 *CatalogSeparator=Sets or gets a string used as the catalog separator for an instance of the SqlCommandBuilder class. ARG(string)|3|2 *DataAdapter=Returns a SqlDataAdapter object for which Transact-SQL statements are automatically generated. ARG(SqlDataAdapter)|3|0 *GetDeleteCommand=Gets the automatically generated SqlCommand object required to perform deletions on the database. ARG(SqlCommand)|3|0 *GetInsertCommand=Gets the automatically generated SqlCommand object required to perform insertions on the database. ARG(SqlCommand)|3|0 *GetUpdateCommand=Gets the automatically generated SqlCommand object required to perform updates on the database. ARG(SqlCommand)|3|0 *QuotePrefix=Returns 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. ARG(string)|3|2 *QuoteSuffix=Returns 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. ARG(string)|3|2 *SchemaSeparator=Returns the character to be used for the separator between the schema identifier and any other identifiers. ARG(string)|3|2 SqlCommandBuilder=Returns the SqlCommandBuilder object. ARG(SqlCommandBuilder)|3|0 *adapter=The name of the SqlDataAdapter. ARG(SqlDataAdapter)|4|0 *command=The SqlCommand referencing the stored procedure from which the parameter information is to be derived. The derived parameters are added to the Parameters collection of the SqlCommand. ARG(SqlCommand)|4|0 *quotedIdentifier=The identifier that will have its embedded quotes removed. ARG(string)|4|2 *unquotedIdentifier=The original unquoted identifier. ARG(string)|4|2 *useColumnsForParameterNames=If true, generate parameter names matching column names if possible. If false, generate @p1, @p2, and so on. ARG(bool)|4|104