SfcObjectQuery.ExecuteDataTable Method

Executes the query string to retrieve the specified fields and return a fully populated data table. Do not reference this member directly in your code. It supports the SQL Server infrastructure.

Namespace:  Microsoft.SqlServer.Management.Sdk.Sfc
Assembly:  Microsoft.SqlServer.Management.Sdk.Sfc (in Microsoft.SqlServer.Management.Sdk.Sfc.dll)

Syntax

'Declaration
Public Function ExecuteDataTable ( _
    query As SfcQueryExpression, _
    fields As String(), _
    orderByFields As OrderBy() _
) As DataTable
'Usage
Dim instance As SfcObjectQuery
Dim query As SfcQueryExpression
Dim fields As String()
Dim orderByFields As OrderBy()
Dim returnValue As DataTable

returnValue = instance.ExecuteDataTable(query, _
    fields, orderByFields)

public DataTable ExecuteDataTable(
    SfcQueryExpression query,
    string[] fields,
    OrderBy[] orderByFields
)

public:
DataTable^ ExecuteDataTable(
    SfcQueryExpression^ query, 
    array<String^>^ fields, 
    array<OrderBy^>^ orderByFields
)

member ExecuteDataTable : 
        query:SfcQueryExpression * 
        fields:string[] * 
        orderByFields:OrderBy[] -> DataTable 

public function ExecuteDataTable(
    query : SfcQueryExpression, 
    fields : String[], 
    orderByFields : OrderBy[]
) : DataTable

Parameters

• query
  Type: Microsoft.SqlServer.Management.Sdk.Sfc.SfcQueryExpression
  The query string to process.

• fields
  Type: array<System.String[]
  The field names to retrieve. If null, all default inexpensive fields are retrieved.

• orderByFields
  Type: array<Microsoft.SqlServer.Management.Sdk.Sfc.OrderBy[]
  The field names that we need to order on. If null, no order will be used.

Return Value

Type: System.Data.DataTable
The data table of results.

See Also

Reference

SfcObjectQuery Class

Microsoft.SqlServer.Management.Sdk.Sfc Namespace