I have tried to use XPathNodeIterator. But for reasons I can figure out, the XPathNodeIterator object only able to provide the first two values in the list. So in the interest of saving time, I had to make a query direct to the the database and looped through the dataset. At least I know XPathNodeIterator was the right way to go.
Thanks