ExecuteSql.ExecuteWithResults Method

Definition

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

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

con
Object

Returns

DataTable

Applies to