共用方式為


SPList.GetItems method (String[])

會傳回從清單中的項目,但包含指定之的欄位值。

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

Syntax

'宣告
Public Function GetItems ( _
    ParamArray fields As String() _
) As SPListItemCollection
'用途
Dim instance As SPList
Dim fields As String()
Dim returnValue As SPListItemCollection

returnValue = instance.GetItems(fields)
public SPListItemCollection GetItems(
    params string[] fields
)

參數

  • fields
    Type: []

    要取得值的欄位名稱的可變數目。如果應該擷取所有欄位,請改用Items屬性。

傳回值

Type: Microsoft.SharePoint.SPListItemCollection
清單項目集合。

Exceptions

Exception Condition
ArgumentNullException

fields是 null 。

備註

此方法會從指定的欄位建立新的SPQuery物件,並呼叫與該新的物件,若要取得之項目的GetItems(SPQuery)方法。

此方法會比存取Items屬性,因為它只會擷取指定之欄位的值。

Examples

下面範例會指定要傳回在項目擷取自] 清單中的欄位值的主控台應用程式。之後正在擷取資料,將應用程式會列印簡單報告主控台。

Imports System
Imports Microsoft.SharePoint

Module ConsoleApp
   Sub Main()
      Using site As SPSite = New SPSite("https://localhost")
         Using web As SPWeb = site.OpenWeb()

            ' Get data from a list.
            Dim listUrl As String = web.ServerRelativeUrl + "/lists/tasks"
            Dim list As SPList = web.GetList(listUrl)
            Dim items As SPListItemCollection = list.GetItems("LinkTitle", "AssignedTo", "DueDate", "Status")

            ' Print a report header.
            Console.WriteLine("{0,-25}  {1,-20}  {2,-25}  {3}", _
                  "Assigned To", "Task", "Due Date", "Status")

            ' Print the details.
            Dim item As SPListItem
            For Each item In items
               Console.WriteLine("{0,-25}  {1,-20}  {2,-25}  {3}", _
                     item("AssignedTo"), item("LinkTitle"), item("DueDate"), item("Status"))
            Next item


         End Using
      End Using
      Console.ReadLine()
   End Sub
End Module
using System;
using Microsoft.SharePoint;

namespace Test
{
   class ConsoleApp
   {
      static void Main(string[] args)
      {
         using (SPSite site = new SPSite("https://localhost"))
         {
            using (SPWeb web = site.OpenWeb())
            {
               // Get data from a list.
               string listUrl = web.ServerRelativeUrl + "/lists/tasks";
               SPList list = web.GetList(listUrl);
               SPListItemCollection items = list.GetItems("LinkTitle", "AssignedTo", "DueDate", "Status");

               // Print a report header.
               Console.WriteLine("{0,-25}  {1,-20}  {2,-25}  {3}",
                  "Assigned To", "Task", "Due Date", "Status");

               // Print the details.
               foreach (SPListItem item in items)
               {
                  Console.WriteLine("{0,-25}  {1,-20}  {2,-25}  {3}",
                     item["AssignedTo"], item["LinkTitle"], item["DueDate"], item["Status"]);
               }
            }
         }
         Console.ReadLine();
      }
   }
}

請參閱

參照

SPList class

SPList members

GetItems overload

Microsoft.SharePoint namespace