SPListItemCollection.GetDataTable 方法

Returns the collection of list items as a data table.

命名空间:  Microsoft.SharePoint
程序集:  Microsoft.SharePoint(位于 Microsoft.SharePoint.dll 中)

语法

声明
Public Function GetDataTable As DataTable
用法
Dim instance As SPListItemCollection
Dim returnValue As DataTable

returnValue = instance.GetDataTable()
public DataTable GetDataTable()

返回值

类型:System.Data.DataTable
A System.Data.DataTable object that contains the list items.

示例

The following code example uses the GetDataTable method to display items in a DataGrid control.

The example assumes the existence of an .aspx page that contains a DataGrid control.

Dim site As SPWeb = SPControl.GetContextWeb(Context)
Dim list As SPList = site.Lists("List_Name")
Dim listItems As SPListItemCollection = list.Items

DataGrid1.DataSource = listItems.GetDataTable()
DataGrid1.DataBind() 
SPWeb oWebsite = SPContext.Current.Web;
SPList oList = oWebsite.Lists["List_Name"];
SPListItemCollection collListItems = oList.Items;

DataGrid1.DataSource = collListItems.GetDataTable();
DataGrid1.DataBind();

另请参阅

引用

SPListItemCollection 类

SPListItemCollection 成员

Microsoft.SharePoint 命名空间