Sharepoint 2010 how to get all items in a folder contained in a list?

Question

I have a list that contains folders.

Using c# and object model, how can I see if the folder contains any items, or return a collection of all the items in that folder.

Answer 1

Try the following code to get the items based on the folder,

using(SPSite site = new SPSite("site url"))
{
  using(SPWeb web = site.OpenWeb())
  {
    SPFolder folder = web.GetFolder("/Docs/folder1");
    if(folder.ItemCount > 0)
    {
      SPList list = web.Lists.TryGetList("ListName");
      SPQuery query = new SPQuery();
      query.Folder = folder;
      SPListItemCollection = list.GetItems(query);
    }
  }
}

Answer 2

You need to use SPQuery Class and define SPQuery.Folder Property

Answer 3

foreach (SPFolder folder in list.Folders) {
    if (folder.ItemCount > 0) {
        foreach (SPFile file in folder.Files) {
            SPListItem item = file.Item;
            // Do stuff with your item here.
        }
        foreach (SPFolder subfolder in folder.SubFolders) {
            // Do stuff with your folder here.
            // Think about perhaps using recursion if you want to list the items from this folder and beyond
        }
    }
}

Because we're using foreach, we don't really need to check if the itemcount is more than 0. But this is just an example to allow you to identify which folders have items and how you can access them