ExecuteSql.ExecuteWithResults Method

Definition

Namespace:

Microsoft.SqlServer.Management.Sdk.Sfc

Assembly:

Microsoft.SqlServer.Management.Sdk.Sfc.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Overloads

ExecuteWithResults(String)	excute a query and return a DataTable with the results
ExecuteWithResults(StringCollection, Object)	execute tsql for the given connection and return the results in the DataTable
ExecuteWithResults(String, Object)	execute the sql for ther given connection returning results in a DataTable
ExecuteWithResults(StringCollection, Object, StatementBuilder)	execute the sql for ther given connection returning results in a DataTable this is a tsql for final results StatementBuilder holds info for additional processing needs and formating information the first tsqls in the list are executed without resulst, results are taken only for the last tsql

ExecuteWithResults(String)

excute a query and return a DataTable with the results

public System.Data.DataTable ExecuteWithResults (string query);

member this.ExecuteWithResults : string -> System.Data.DataTable

Public Function ExecuteWithResults (query As String) As DataTable

Parameters

query

String

Returns

DataTable

ExecuteWithResults(StringCollection, Object)

execute tsql for the given connection and return the results in the DataTable

public static System.Data.DataTable ExecuteWithResults (System.Collections.Specialized.StringCollection query, object con);

static member ExecuteWithResults : System.Collections.Specialized.StringCollection * obj -> System.Data.DataTable

Public Shared Function ExecuteWithResults (query As StringCollection, con As Object) As DataTable

Parameters

query

StringCollection

con

Object

Returns

DataTable

ExecuteWithResults(String, Object)

execute the sql for ther given connection returning results in a DataTable

public static System.Data.DataTable ExecuteWithResults (string query, object con);

static member ExecuteWithResults : string * obj -> System.Data.DataTable

Public Shared Function ExecuteWithResults (query As String, con As Object) As DataTable

Parameters

query

String

con

Object

Returns

DataTable

ExecuteWithResults(StringCollection, Object, StatementBuilder)

execute the sql for ther given connection returning results in a DataTable this is a tsql for final results StatementBuilder holds info for additional processing needs and formating information the first tsqls in the list are executed without resulst, results are taken only for the last tsql

public static System.Data.DataTable ExecuteWithResults (System.Collections.Specialized.StringCollection query, object con, Microsoft.SqlServer.Management.Sdk.Sfc.StatementBuilder sb);

static member ExecuteWithResults : System.Collections.Specialized.StringCollection * obj * Microsoft.SqlServer.Management.Sdk.Sfc.StatementBuilder -> System.Data.DataTable

Public Shared Function ExecuteWithResults (query As StringCollection, con As Object, sb As StatementBuilder) As DataTable

Parameters

query

StringCollection

con

Object

sb

StatementBuilder

Returns

DataTable