SharePoint

Retrieve items from a particular folder of a list

0There are times when we need to fetch only the items within a specific folder. In those cases we can use the ‘Folder’ property of SPQuery class. Simply set the ‘Folder’ property to a Folder object which represents the folder instance from where we need the items.

  Reference URL: http://spdeveloper.co.in/articles/pages/get-items-from-a-specific-folder-in-sharepoint-list.aspx

SharePoint

Pagination using SPQuery C#

0There is something you really need to know, YOU CAN DO PAGINATION USING SPQUERY!!!!!!!! Yes, below is the code i have implemented

  Reference URLs: http://blogs.msdn.com/b/colbyafrica/archive/2009/02/19/learning-sharepoint-part-vi-list-pagination.aspx https://code.msdn.microsoft.com/office/CSSharePointPaginationWebPa-b44c8073/sourcecode?fileId=61645&pathId=1225843244 http://www.tekritisoftware.com/implement-paging-using-caml-query-sharepoint2010  

SharePoint

Dynamic CAML Query using C#

0So i had a requirement where i had to create a CAML query dynamically based on user inputs, after googling, i found some solutions, but this helped be Reference url: https://shahjinesh11.wordpress.com/2013/12/26/how-to-create-caml-query-dynamically-in-sharepoint/

Now, you can prepare your query and call the function as per below to create dynamic query: