Actually, if you use a stored proc/command object as the basis of fetching/retrieving data, and rely on a RS as only a way to move data around, you won't have a problem... The RS sucks as a way of updating data. In reality, the RS uses a command to do the updating. However, by using the RS itself, alot of implicit actions occur. Best to make great use of the Command Object.

It's not nonsense...Rather, it is a matter of understanding how this stuff works. Like everything, ADO has it's quirks.