ServerConnection.ExecuteWithResults Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.DataSetPublic Function ExecuteWithResults (sqlCommand As String) As DataSetParameters
- 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.DataSetPublic Function ExecuteWithResults (sqlCommand As String, retry As Boolean) As DataSetParameters
- sqlCommand
- String
- retry
- Boolean
Whether we should retry if an exception is thrown during execution