HostIntegratorSession.PerformTableProcedure Method (String, String, IDictionary, Boolean, IList, Int32)

Performs a SELECT procedure on a table defined in the model.

public DataSet PerformTableProcedure(
   string tableName,
   string procedureName,
   IDictionary filterValues,
   bool filterIsCaseSensitive,
   IList outputColumnNames,
   int maxRows
);

Parameters

tableName: Specifies the name of the table on which to perform the procedure.
procedureName: Specifies the name of the table procedure to perform.
filterValues: Specifies a set of filter column name-value pairs to use.
filterIsCaseSensitive: Specifies whether the filter comparison should be case sensitive.
outputColumnNames: Specifies the names of the columns to return.
maxRows: Specifies the maximum number of rows to return. If maxRows is set to 0, no limit is imposed on the number of rows returned.

Return Value

This method returns the result of a SELECT procedure. If no data match the specified conditions, this method returns an empty DataSet.

Remarks

Performs a SELECT procedure on a table defined in the model.

Exceptions

Exception Type	Condition
HostIntegratorModelDefException	Thrown if a reference is made to a non-existent table, procedure, or table column
HostIntegratorConnectorException	Thrown if client is not connected
HostIntegratorException	Thrown if the connection is for metadata only
HostIntegratorServerException	Thrown if an error occurs while performing the procedure

HostIntegratorSession.PerformTableProcedure Method (String, String, IDictionary, Boolean, IList, Int32)

Parameters

Return Value

Remarks

Exceptions

See Also