SPList.AppendDataTable Method

Appends the results returned by a query to an existing data table.

Namespace:  Microsoft.SharePoint
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)
Available in Sandboxed Solutions: No
Available in SharePoint Online

Syntax

'Declaration
<SubsetCallableExcludeMemberAttribute(SubsetCallableExcludeMemberType.ShimmedTypeOutParam)> _
Public Sub AppendDataTable ( _
    query As SPQuery, _
    flags As SPListGetDataTableOptions, _
    dataTable As DataTable, _
    <OutAttribute> ByRef position As SPListItemCollectionPosition _
)
'Usage
Dim instance As SPList
Dim query As SPQuery
Dim flags As SPListGetDataTableOptions
Dim dataTable As DataTable
Dim position As SPListItemCollectionPosition

instance.AppendDataTable(query, flags, _
    dataTable, position)

[SubsetCallableExcludeMemberAttribute(SubsetCallableExcludeMemberType.ShimmedTypeOutParam)]
public void AppendDataTable(
    SPQuery query,
    SPListGetDataTableOptions flags,
    DataTable dataTable,
    out SPListItemCollectionPosition position
)

Parameters

• query
  Type: Microsoft.SharePoint.SPQuery

  The query that will be used to select data. Only the fields that are specified in the query are returned.

• flags
  Type: Microsoft.SharePoint.SPListGetDataTableOptions

  An enumeration value that specifies options for populating the data table with the values of fields in list items.

• dataTable
  Type: System.Data.DataTable

  A data table to receive the results of the query.

• position
  Type: Microsoft.SharePoint.SPListItemCollectionPosition

  A reference to an object that will receive paging information.

Exceptions

See Also

Reference

SPList Class

SPList Members

Microsoft.SharePoint Namespace

GetDataTable(SPQuery, SPListGetDataTableOptions, SPListItemCollectionPosition)