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.