Questions tagged [spquery]

SPQuery represents a query in a SharePoint list view. Collaborative Application Markup Language (CAML) can be used to define the query.

Example:

SPWeb oWebsiteRoot = SPContext.Current.Site.RootWeb
SPList oList = oWebsiteRoot.Lists["Tasks"];

SPQuery oQuery = new SPQuery();
oQuery.Query = "<Where><Eq><FieldRef Name='Status'/>" + 
               "<Value Type='Text'>Completed</Value></Eq></Where>";

SPListItemCollection collListItems = oList.GetItems(oQuery);

foreach (SPListItem oListItem in collListItems)
{
    Response.Write(SPEncode.HtmlEncode(oListItem["Title"].ToString()) + 
        "<BR>");
}

MSDN - SPQuery