Partilhar via

SfcObjectQuery.ExecuteDataTable Method

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Sdk.Sfc
Assembly:
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Execute the query string to retrieve the specified fields and return a fully populated DataTable.

public System.Data.DataTable ExecuteDataTable (Microsoft.SqlServer.Management.Sdk.Sfc.SfcQueryExpression query, string[] fields, Microsoft.SqlServer.Management.Sdk.Sfc.OrderBy[] orderByFields);
member this.ExecuteDataTable : Microsoft.SqlServer.Management.Sdk.Sfc.SfcQueryExpression * string[] * Microsoft.SqlServer.Management.Sdk.Sfc.OrderBy[] -> System.Data.DataTable
Public Function ExecuteDataTable (query As SfcQueryExpression, fields As String(), orderByFields As OrderBy()) As DataTable

Parameters

query
SfcQueryExpression

The query string to process.

fields
String[]

The field names to retrieve. If null, all default inexpensive fields are retrieved.

orderByFields
OrderBy[]

The field names that we need to order on. If null no order will be used.

Returns

DataTable

The data table of results.

Applies to