dimanche 8 mars 2015

CAML QUERY ORDERBY IS NOT WORKING



SPWeb _SPweb = _SPSite.OpenWeb(); SPList _SPlist = _SPweb.Lists[FL.ToString()];



SPQuery _spquery = new SPQuery();
_spquery.Query = "<Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>now</Value></Eq></Where><OrderBy><FieldRef Name='Date_Of_x0020__Posted' Ascending='False' /></OrderBy></Query>";//"<Query><OrderBy><FieldRef Name='Date_Of_x0020__Posted' Ascending='false' /></OrderBy></Query>";///CAMLquery for oderby posted date


SPListItemCollection FaqCollection = _SPlist.GetItems(_spquery);


if (FaqCollection != null || FaqCollection.Count <= 0)
{

foreach (SPListItem item in FaqCollection)

{


}


}


ABOVE CODE BUNCH RETRIEVING THE DATA FROM lIST BUT NOT ORDERING,IT WAS WORKING PERFECT,AT ONCE ITS NOT WORKING...WHAT I HAVE MISSED HERE


THANK ALL








0 commentaires:

Enregistrer un commentaire