Sorted this problem too.

Strangely i changed the da code to return a dataset and it does pull back all rows

I can only assume that the recordset was in an xml format and the sqldatareader didn't error, but just picked up the first row.

and i guess the dataset was able to pick up the whole structure of the recordset.

oh well it works.