Udostępnij za pośrednictwem


ServerConnection.ExecuteWithResults Method

Definition

Overloads

ExecuteWithResults(StringCollection)

Executes the T-SQL statements in the StringCollection. An array of DataSets are returned that contain the results for each statement in the StringCollection. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

ExecuteWithResults(String)

Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

ExecuteWithResults(String, Boolean)

Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

ExecuteWithResults(StringCollection)

Executes the T-SQL statements in the StringCollection. An array of DataSets are returned that contain the results for each statement in the StringCollection. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

public System.Data.DataSet[] ExecuteWithResults (System.Collections.Specialized.StringCollection sqlCommands);
member this.ExecuteWithResults : System.Collections.Specialized.StringCollection -> System.Data.DataSet[]
Public Function ExecuteWithResults (sqlCommands As StringCollection) As DataSet()

Parameters

sqlCommands
StringCollection

Returns

Applies to

ExecuteWithResults(String)

Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

public System.Data.DataSet ExecuteWithResults (string sqlCommand);
member this.ExecuteWithResults : string -> System.Data.DataSet
Public Function ExecuteWithResults (sqlCommand As String) As DataSet

Parameters

sqlCommand
String

Returns

Applies to

ExecuteWithResults(String, Boolean)

Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

public System.Data.DataSet ExecuteWithResults (string sqlCommand, bool retry);
member this.ExecuteWithResults : string * bool -> System.Data.DataSet
Public Function ExecuteWithResults (sqlCommand As String, retry As Boolean) As DataSet

Parameters

sqlCommand
String
retry
Boolean

Whether we should retry if an exception is thrown during execution

Returns

Applies to