Thursday, 26 July 2012

Using CAML Query to Get Data from SharePoint List


 SPWeb oWebsite = SPContext.Current.Web;


            SPList objList = oWebsite.Lists["Emloyess Data"];
           const string camelQry= @"<Query><Where><And><Eq><FieldRef Name='Title' /><Value Type='Text'>Sharepoint Developer</Value></Eq><Eq><FieldRef Name='Name' /><Value Type='Text'>Amjad Ali Khawaja</Value></Eq></And></Where></Query>";
           SPQuery sp = new SPQuery();
           sp.Query = camelQry;
           SPListItemCollection splc = objList.GetItems(sp);

           foreach (SPListItem li in splc)
           {
               Label1.Text += li["Title"] + " " + li["Name"] + " " + li["ID"]  ;
           }
}

No comments:

Post a Comment