ExecuteSql.ExecuteWithResults Método

Definición

Espacio de nombres:: Microsoft.SqlServer.Management.Sdk.Sfc

Ensamblado:: Microsoft.SqlServer.Management.Sdk.Sfc.dll

Paquete:: Microsoft.SqlServer.SqlManagementObjects v150.18208.0

Paquete:: Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Paquete:: Microsoft.SqlServer.SqlManagementObjects v172.64.0

Importante

Parte de la información hace referencia a la versión preliminar del producto, que puede haberse modificado sustancialmente antes de lanzar la versión definitiva. Microsoft no otorga ninguna garantía, explícita o implícita, con respecto a la información proporcionada aquí.

Sobrecargas

Nombre	Description
ExecuteWithResults(String)	excute una consulta y devuelva una DataTable con los resultados
ExecuteWithResults(StringCollection, Object)	ejecute tsql para la conexión especificada y devuelva los resultados en DataTable.
ExecuteWithResults(String, Object)	ejecute sql para la conexión especificada que devuelve resultados en dataTable.
ExecuteWithResults(StringCollection, Object, StatementBuilder)	execute the sql for ther given connection return 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 una consulta y devuelva una DataTable con los resultados

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

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

Public Function ExecuteWithResults (query As String) As DataTable

Parámetros

query: String

Devoluciones

DataTable

Se aplica a

ExecuteWithResults(StringCollection, Object)

ejecute tsql para la conexión especificada y devuelva los resultados en 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

Parámetros

query: StringCollection

con: Object

Devoluciones

DataTable

Se aplica a

ExecuteWithResults(String, Object)

ejecute sql para la conexión especificada que devuelve resultados en 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

Parámetros

query: String

con: Object

Devoluciones

DataTable

Se aplica a

ExecuteWithResults(StringCollection, Object, StatementBuilder)

execute the sql for ther given connection return 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

Parámetros

query: StringCollection

con: Object

sb: StatementBuilder

Devoluciones

DataTable

Se aplica a