HostIntegratorSession.ExecuteSQLStatement Method (String, Int32)

Executes an SQL statement on a table defined in the model.

public virtual DataSet ExecuteSQLStatement(
string sqlStatement,
int maxRows
);

sqlStatement: Specifies the SQL statement to execute.
maxRows: Specifies the maximum number of rows to return. A value of zero will return all rows.

This method returns a DataSet containing the results of the query. If no data are returned, this method returns an empty DataSet.

Executes an SQL statement on a table defined in the model.

Exception Type	Condition
HostIntegratorModelDefException	Thrown if the SQL statement cannot be resolved
HostIntegratorTerminalException	Thrown if there is an execution error
HostIntegratorConnectorException	Thrown when client is not connected
HostIntegratorException	Thrown if the connection is for metadata only