Поделиться через

  • Статья

Метод ExecuteDataTable

Executes the query string to retrieve the specified fields and return a fully populated data table. Не ссылайтесь на этот элемент непосредственно из кода. Он поддерживает работу инфраструктуры SQL Server.

Пространство имен:  Microsoft.SqlServer.Management.Sdk.Sfc
Сборка:  Microsoft.SqlServer.Management.Sdk.Sfc (в Microsoft.SqlServer.Management.Sdk.Sfc.dll)

Синтаксис

'Декларация
Public Function ExecuteDataTable ( _
    query As SfcQueryExpression, _
    fields As String(), _
    orderByFields As OrderBy() _
) As DataTable
'Применение
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

Параметры

  • fields
    Тип: array<System. . :: . .String> [] () [] []
    The field names to retrieve. If null, all default inexpensive fields are retrieved.

Возвращаемое значение

Тип: System.Data. . :: . .DataTable
The data table of results.