SPList class
代表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. |
Thread safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.