invalid row count

From: Michael Randall (michael_at_randall-design.com)
Date: 03/20/04 

Date: Sat, 20 Mar 2004 08:16:05 -0800

Hello.

i am building a shopping cart program using ASP.NET, VB.NET and SQL Server 2000.

The cart itself is functioning, however, I am having difficult with the order admin section.

The cart is dropping the order and order detail information into two separate tables connected by a foregin key. Again, this part is working. Using Visual Studio.NET or Enterpirse Manager, I can see the order information in the database. However, wheren trying to acces this information through the order admin section of the web application, I am getting an "invalid row count" error.

I have checked my SQL server logs, but they do not containt any mention of this or any error be generated from this application.

I have placed the VB.NET class I am using online so you can see the code:

http://www.randall-design.com/invalidrowcount.htm

Please note that there are four separate functions for accessing the order information, by most recent, by dates between, by orders and by verified. Each of these four functions return the same error.

Does anyone have any thoughts on what is happening?

I have searched online and through a number of newsgroups, but so far I have found nothing useful.

Thanks,

Michael