The way above is pretty close to what I do, but I use a bit different approach since I'm dealing with XML data.
Since you're using c#, You might want to use the XElement class to parse your XML. It gives you the ability to use LINQ queries on your XML.
For your above issue, the first thing I do is create an XML query from scratch using XElement:
XElement lookupCurrentXML = new XElement("SearchReport",
new XElement("DisplayFields",
new XElement("DisplayField", "26675")
),
new XElement("PageSize", "250"),
new XElement("Criteria",
new XElement("Keywords", ""),
new XElement("Filter",
new XElement("OperatorLogic", ""),
new XElement("Conditions",
new XElement("CurrentDateFilterCondition",
new XElement("Field", "26686"),
new XElement("Operator", "CurrentYear")
)
)
),
new XElement("ModuleCriteria",
new XElement("Module", "528"),
new XElement("IsKeywordModule", "True"),
new XElement("BuildoutRelationship", "Union"),
new XElement("SortFields",
new XElement("SortField",
new XElement("Field", "26675"),
new XElement("SortType", "Ascending")
)
)
)
)
);
The reason why I do this is to make sure I don't have a report someone messes up or deletes. I can store all of my XML queries in a separate library and just call the one I need to, then pass the XML into the ExecuteSearch method.
Next, I do my initial lookup:
XElement LookupRecs = XElement.Parse(wsArcherSearch.ExecuteSearch(sessionToken, lookupXML.ToString(), 1));
From that, I can now parse out my XML and get counts where I need to.
I create a couple of numeric fields to store two separate counts - my total records in my query, and my page total):
int recCount = Convert.ToInt32(LookupRecs.Attribute("count").Value);
int recsInLookuprecs = LookupRecs.Elements("Record").Count();
int x = 2;
See how on the 2nd value I can just grab a count of records in my XML? Comes in handy since SQL tables can return stuff in different orders at times. The last thing I do is create a page increment value (cause you can only have 250 records on a single page). Now, I can do my while loop and make sure I loop through all the records on each page:
//if there are more than 250 records on a page, there are multiple pages to the report. We need to retrieve them all and store them in one big XML record
while (recsInLookuprecs != recCount)
{
XElement LookupMoreRecs = XElement.Parse(wsArcherSearch.ExecuteSearch(sessionToken, lookupXML.ToString(), x));
LookupRecs.Add(LookupMoreRecs.Elements("Record"));
recsInLookuprecs = LookupRecs.Elements("Record").Count();
x++;
}
Doing it this way allows you to grab entire pieces of data using LINQ queries:
var monthlyRecs = (from recsMain in LookupRecs.Elements("Record")
from recs in recsMain.Attributes("contentId")
select recs.Value).ToList();
Hope this helps...
