Export (0) Print
Expand All

SPQuery.ViewFields Property

Windows SharePoint Services 3

Gets or sets the fields that are returned in the query.

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

public string ViewFields { get; set; }

Property Value

Type: System.String
A string that contains a fragment in Collaborative Application Markup Language that specifies the view fields.

The ViewFields property allows you to specify which fields to return in a query on a list.

The ViewFields property contains a string that corresponds to the inner XML of the ViewFields element in CAML.

The following code example uses the ViewFields property to specify two fields to return in a query.

This example requires using directives (Imports in Microsoft Visual Basic) for the [Microsoft.SharePoint] and [Microsoft.SharePoint.Utilities] namespaces.

using (SPWeb oWebsite = SPContext.Current.Site.AllWebs["Site_Name"])
    SPList oList = oWebsite.Lists["List_Name"];

    SPQuery oQuery = new SPQuery();
    oQuery.ViewFields = "<FieldRef Name='Field1'/>" +
        "<FieldRef Name='Field2'/>";
    SPListItemCollection colListItemsAvailable = 

    foreach (SPListItem oListItemAvailable in colListItemsAvailable)
        Response.Write(SPEncode.HtmlEncode(oListItemAvailable.Xml) + 

Certain objects implement the IDisposable interface, and you must avoid retaining these objects in memory after they are no longer needed. For information about good coding practices, see Best Practices: Using Disposable Windows SharePoint Services Objects.

Community Additions

© 2014 Microsoft