SPListItemCollection Get ItemCount with rowlimit

Question

I am filtering a list in caml

SPQuery oQuery = new SPQuery();
oQuery.Query = "<OrderBy><FieldRef Name='FullName' /></OrderBy><Where><Contains><FieldRef Name='FirstName' /><Value Type='Text'>e</Value></Contains></Where>";

using (SPSite siteCollection = new SPSite("http://localhost/"))
{
    using (SPWeb web = siteCollection.OpenWeb())
    {
        SPList oList = web.Lists["Profile"];
        SPListItemCollection items = null;

        oQuery.ViewFields = "<FieldRef Name='FullName'/>";
        oQuery.RowLimit = 2;

        items = oList.GetItems(oQuery);

        if (items.Count > 0)
        {
            foreach (SPListItem item in items)
            {
                Console.WriteLine("Full Name: {0}",
                        item["FullName"]);
            }

            Console.WriteLine("Count: {0} | Count Query: {1} ",
                    items.Count,
                    items.List.ItemCount);
        }
    }
}

I'm using the SPListItemCollection.List.ItemCount, who is returning the value of 50 records. However records are 50 total items on my list, and I would like to know the total records on this list with the filter that actually are 22.

What is the best method to find this value? Thanks

Answer 1

This is not working for you?

SPQuery query = new SPQuery() { Query = "<OrderBy><FieldRef Name='FullName' /></OrderBy><Where><Contains><FieldRef Name='FirstName' /><Value Type='Text'>e</Value></Contains></Where>" };
SPList oList = web.Lists["Profile"];
SPListItemCollection items = oList.GetItems(query);
int count = items.Count;

Please let me know

Actually you are getting the count in a wrong way, SPListItemCollection.List gives you the parent SPList item, on this whole List you are getting ItemCount which will essentially gives you the total number of items in the list, why are not you directly getting the count as items.Count ?

Answer 2

If you are looking to limit the number of items returned by the server object model and at the same time build some kind of paging UI, use SPQuery.ListItemCollectionPosition property.

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spquery.listitemcollectionposition.aspx

This following article cover its usage in details: http://apmblog.compuware.com/2009/01/15/sharepoint-page-through-sharepoint-lists/