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
参数
- query
类型:Microsoft.SqlServer.Management.Sdk.Sfc. . :: . .SfcQueryExpression
The query string to process.
- fields
类型:array<System. . :: . .String> [] () [] []
The field names to retrieve. If null, all default inexpensive fields are retrieved.
- orderByFields
类型:array<Microsoft.SqlServer.Management.Sdk.Sfc. . :: . .OrderBy> [] () [] []
The field names that we need to order on. If null, no order will be used.
返回值
类型:System.Data. . :: . .DataTable
The data table of results.