Group By SPListItem in SharePoint ListItemCollection

The CAML Query does not support group by object collection. The other workaround is to get the object and group by LINQ query try { using (SPSite oSiteCollection = new SPSite(webUrl)) { using (SPWeb oWebsite = oSiteCollection.OpenWeb()) { SPList listName = oWebsite.Lists.TryGetList("MCS"); if (listName != null) { SPView myView = listName.Views["GroupBy"]; if (myView != null)... Continue Reading →

LINQ Query to SharePoint List using Contains with Array

SPMetal tool folder location C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\ Command to create a Entity class for the site SPMetal /web:http://<servername>/site /namespace:<namesp> /code:filename.cs ex: SPMetal /web:http://senthamil/sites/sample /namespace:Sample /code:Sample.cs The sample.cs file will be generated with the Lists and the content type information. To compare with the array of document names in the document library, a... Continue Reading →

Create a website or blog at WordPress.com

Up ↑