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:


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:  


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:

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