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