Different SPList.Items.Count & SPList.ItemCount

Question

A list on my site gives 2 when I call myList.ItemCount. But myList.Items.Count gives me zero and I can't access the items stored in the list. AllItems.aspx show me the two missing items.

Any ideas?

Answer 1

I remember that @furuknap once pointed out that ItemCount and Items.Count are different in the way they treat SPFolders (inclusive and exclusive). Also, ItemCount is faster because it gets a static SPList property instead of building the SPListItemCollection object before counting its members.

Answer 2

I looked closely with Reflector and found this, SPList.Items returns the list items by running a query with Scope=Recursive ViewAttribute. I don't have enough time to do some research on the topic but simply running a query with no attributes gave me my items.

Answer 3

Permissions might be the issue. I ran into the same thing, and it turned out that I forgot to make the list accessible.

http://stackoverflow.com/questions/3823338/why-cant-i-access-the-items-in-a-list-even-if-the-splist-itemcount-is-0

Answer 4

Check whether the user u logged in may not assigned in ur site collection..... i too meet the same problem.... now cleared.....

add the u user what u logged in to the site collection and then check it....

Answer 5

SPList.ItemCount is the efficient and recommended way to retrieve items count in a list.

However, It should be noted that this property is fine tuned for performance which may cause the side effect of returning unexpected count. So, if you need the exact count, you should use the poorer performing SPList.Items.Count or SPList.GetItems(SPQuery query).Count