SPlist的使用
SPSite oSiteCollection = SPContext.Current.Site;
SPList oList = oSiteCollection.AllWebs["/"].Lists["testlist2"];
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: " +
SPEncode.HtmlEncode(oListItem["Title"].ToString()) +
"::" + "Value: " +
oListItem["Investment"].ToString() +
"::" + "Calculated: " +
oListItem["ProjectedValue"].ToString()+
"<BR>";
}
