SafeDataReader returning only one row

Old forum URL: forums.lhotka.net/forums/t/3949.aspx

checlark posted on Wednesday, November 28, 2007

Has anyone had the SafeDataReader only return one row when you are sure there is more than one? I have ten rows in the table but the SDR only returns one. Any suggestions? BTW this started occurring when I setup the wcfportal and started porting to wpf client.

Michael Hildner replied on Wednesday, November 28, 2007

Not sure if this is your case, and I haven't used wcf, but the times I've seen that happen is when I've screwed up and had a dr.NextResult() where there shouldn't be one.

Regards,

Mike

checlark replied on Wednesday, November 28, 2007

Thanks for the nudge Mike! That was indeed the problem.