Executes a SQL statement against the current data source for this database.

public string ExecuteSQLStatement(string SQLStatement,
	Values ParametersCollection);

Return Value

If the SQL statement failed or some error occurred, the return value is blank. If the SQL statement doesn't create a result set (for example, a SQL UPDATE or INSERT statement), "1" is returned. Otherwise, the return value is the result set as an attribute-based XML string.


The SQL statement to execute.

If you use a parameterized SQL statement or call a stored procedure that receives parameters, ExecuteSQLStatement needs a source for the values of the parameters.


See also:

Class Database