Executes an SQL query against the specified connection.
Namespace:
BlueCieloECM.InnoCielo.Meridian.Scripting
Assembly:
BlueCieloECM.InnoCielo.Meridian (in BlueCieloECM.InnoCielo.Meridian.dll) Version: 4.0.0.0 (4.0.111.0)
Syntax public Array ExecSQL(
string connectionString,
string query,
IEnumerable<Object> parameters
)
Public Function ExecSQL (
connectionString As String,
query As String,
parameters As IEnumerable(Of Object)
) As Array
Parameters
- connectionString
- Type: SystemString
The connection string that includes the source database name,
and other parameters needed to establish the initial connection.
- query
- Type: SystemString
The SQL query to execute.
- parameters
- Type: System.Collections.GenericIEnumerableObject
The collection of parameters for the query
(in the same order they appear in the SQL expression).
Return Value
Type:
Array
A 2D array of values ([column, row]) that represents the SQL result.
If no result, an empty array.
See Also