I have no issue with using ADO or not.  Is there some particular benefit from using ADO and datasets in your solution?
The approach from DataPig is very simple and allows the developer to avoid ADO and data sets when returning data from a proc, with or without parameters.
I used to use ADO and write a lot of VBA until I found this alternative approach, which I have used successfully in several corporate environments.

I would prefer to run everything from the web with browser-based ASP.Net components or to use Sharepoint as a foundation, but when this has not been possible ( IT politics ), the non-coded approach is is easy, quick and reliable.

Regards,
Leo