is there such an animal as a Datareader Recordcount using ADO.NET - the RecordsAffecfted seems to only apply to Updates, Deletes etc - not Selects. Do I have to write a function which reads the datareader and add up the numbers. Is my datareader then at the end of the recordset and I have to close it and start again to actually process the data. The documentation is rather confusing - If someone could help I would greatly appreciate it

thanks Brian H