Share via


SPList.GetDataTable method

Retrieves a data table that contains item data that satisfies a query.

Namespace:  Microsoft.SharePoint
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)

Syntax

'Declaration
Public Function GetDataTable ( _
    query As SPQuery, _
    flags As SPListGetDataTableOptions, _
    <OutAttribute> ByRef position As SPListItemCollectionPosition _
) As DataTable
'Usage
Dim instance As SPList
Dim query As SPQuery
Dim flags As SPListGetDataTableOptions
Dim position As SPListItemCollectionPosition
Dim returnValue As DataTable

returnValue = instance.GetDataTable(query, _
    flags, position)
public DataTable GetDataTable(
    SPQuery query,
    SPListGetDataTableOptions flags,
    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.

Return value

Type: System.Data.DataTable
A data table that contains the result of the query. Each row in the table represents a list item that satisfies the query. Each column represents a field that was specified in the query.

Exceptions

Exception Condition
ArgumentNullException

The query parameter is a null reference。

See also

Reference

SPList class

SPList members

Microsoft.SharePoint namespace

GetDataTable()

GetItems(SPQuery)

AppendDataTable(SPQuery, SPListGetDataTableOptions, DataTable, SPListItemCollectionPosition)

SPListItemCollectionPosition