How to  Get column item from ienumerable list

Solution:

  IEnumerable<ListItem> lc = r.ToList();
 var Items = (from p in lc
                                               where (p["Issue_x0020_Type"].ToString().Trim()) == "Closed"
                                               group p by DateTime.Parse(p["Create_x0020_Date"].ToString()).Month                                                 into g
                                               select new { month = g.Key, count = g.Count() });

Here Create_x0020_Date is column name  .

Comments

Post a Comment

Popular posts from this blog

Metalogix Exception thrown: Server was unable to process request. ---> Value does not fall within the expected range. Solution : Look for app pool .Is posible reset iis .
Read more
REST API The Basics Before it can do anything with SharePoint, your remote Web or mobile application must obtain authorized access. In SharePoint 2013 there are two general approaches to authorizing access to a SharePoint site (regardless of whether you’re using REST). The first approach involves authenticating a SharePoint user, in which case your application has the same access to SharePoint data and capabilities as the user. The different ways you can authenticate a user from a Web or mobile application are outside the scope of this article, but we’ll briefly mention two new options in SharePoint 2013 because they affect the way you construct your REST requests: If you’re calling into SharePoint from a remotely hosted application that can’t use client-side code (HTML and JavaScript) exclusively, and there’s no firewall between SharePoint and your application, you can use OAuth 2.0 tokens with Microsoft Access Control Service (ACS) as the secure token server. If client-side ...
Read more
Image
Allow SharePoint 2013 site to load into IFRAME in non-SharePoint application add the code highligted to all of your master pages if you have multiple masterpages. <WebPartPages:AllowFraming runat="server" />
Read more