Accessing last record in a sharepoint list via CAML query

sharepoint caml
Mehboob Ali picture Mehboob Ali · Nov 4, 2009 · Viewed 9.8k times · Source

i ve some problem in accessing last record from sharepoint list through CAML query,can any one help me in this regrad;i have a sample list called 'MainHeads' which contains the information like HeadID,Category,and headName....

Mehboob Pakistan

Answer

Francisco Aquino picture Francisco Aquino · Dec 8, 2009 
<View>
<RowLimit>1</RowLimit>
<Query>
   <OrderBy>
      <FieldRef Name='Created' Ascending='False' />
   </OrderBy>
</Query>
</View>

Related questions

CAML query with nested ANDs and ORs for multiple fields

I am working on proof-of-concept code to dynamically generate CAML based on keywords provided to a highly-specific search web service that I am writing. I am not using the SharePoint-provided search web service for this proof. I have done so …

Read More
One or more field types are not installed properly. Go to the list settings page to delete these fields

CamlQuery query = new CamlQuery(); query.ViewXml = @"<View>" + "<Query>" + "<Where><Eq><FieldRef Name='Name' /><Value Type='Text'>" + fileName + "</Value>" + "</Eq>" + "</Where>" + "</Query&…

Read More
Getting list item field values from a SP List using Client Object Model

What is the optimal way to get a list items and their properties from a SP list using Client object model? Here is the code I'm using. string server = "http://localhost"; ClientContext context = new ClientContext(server); Web web = context.Web; …

Read More