SPList class

發行項
05/05/2015

代表Microsoft SharePoint Foundation網站上的清單。

Inheritance hierarchy

System.Object
  Microsoft.SharePoint.SPSecurableObject
    Microsoft.SharePoint.SPList
      Microsoft.SharePoint.SPDocumentLibrary
      Microsoft.SharePoint.SPIssueList

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

Syntax

'宣告
Public Class SPList _
    Inherits SPSecurableObject
'用途
Dim instance As SPList

public class SPList : SPSecurableObject

備註

清單中包含的項目或列和欄或包含資料的欄位。Items屬性傳回的項目在清單中，而且Fields屬性會傳回欄位的集合清單中。若要改善效能，它是能夠使用其中一個GetItem*方法，從清單中傳回的項目篩選過的集合的最佳作法。

各種SPList屬性、 ParentList屬性及其他屬性或Microsoft.SharePoint命名空間中類別的方法傳回清單之集合的特定的內容。否則請使用 [ SPWeb ] 或 [ SPList類別之Lists屬性可在網站或清單的上層清單的集合中傳回SPListCollection物件，代表其中一個清單的集合。若要從集合中傳回單一清單使用索引器。例如，若集合已指派給變數collLists，使用以 C# collLists[index]或collLists(index) Visual Basic，其中index是在集合中，[] 清單中的顯示名稱之清單的索引編號，或清單的 GUID。

Examples

下列程式碼範例會傳回並顯示指定的清單中的"ProjectedValue"欄位的值超過 500 個項目。此範例假設有一個包含 label 控制項的.aspx 頁面。

這個範例需要Microsoft.SharePoint和Microsoft.SharePoint.Utilities命名空間using指示詞 (在 Visual Basic 中的Imports )。

Dim siteCollection As SPSite = SPContext.Current.Site
Try

    Dim list As SPList = siteCollection.AllWebs("Site_Name").Lists("List_Name")
    Dim query As New SPQuery()
    query.Query = "<Where><Gt><FieldRef Name='ProjectedValue'/>" + "<Value Type='Number'>500</Value></Gt></Where>"
    Dim listItems As SPListItemCollection = list.GetItems(query)
            
        Dim listItem As SPListItem
        For Each listItem In  listItems
            Label1.Text += "Item: " + SPHttpUtility.HtmlEncode(listItem("Title").ToString()) + 
            "::" + "Value: " + SPHttpUtility.HtmlEncode(listItem("Investment").ToString()) + 
            "::" + "Calculated: " + SPHttpUtility.HtmlEncode(listItem("ProjectedValue").ToString()) + "<BR>"
        Next listItem
Finally
    siteCollection.Dispose()
End Try

SPSite oSiteCollection = SPContext.Current.Site;
SPList oList = oSiteCollection.AllWebs["Site_Name"].Lists["List_Name"];

SPQuery oQuery = new SPQuery();
oQuery.Query = "<Where><Gt><FieldRef Name='ProjectedValue'/>" +
    "<Value Type='Number'>500</Value></Gt></Where>";
SPListItemCollection collListItems = oList.GetItems(oQuery);

foreach (SPListItem oListItem in collListItems)
{
    Label1.Text += "Item: " + 
        SPHttpUtility.HtmlEncode(oListItem["Title"].ToString()) + 
        "::" + "Value: " +   
        SPHttpUtility.HtmlEncode(oListItem["Investment"].ToString()) +
        "::" + "Calculated: " + 
        SPHttpUtility.HtmlEncode(oListItem["ProjectedValue"].ToString()) + 
        "<BR>";
    }
}

After instantiating an SPQuery object, the example uses Collaborative Application Markup Language (CAML) to define criteria for the query, which is passed as a parameter in the GetItems method. For information about CAML, see Collaborative Application Markup Language.

注意事項
For information about how to use Language-Integrated Query (LINQ) queries to retrieve list items in SharePoint Foundation, see Managing Data with LINQ to SharePoint.