Great idea...
What would be even better is if you could have go through all the SPs in a database and create a class with methods for each of these SPs that provide the wrappers.
That way you can always stay in sync and see at a glance what the parms are.
+++ Rick ---
>I've uploaded a little utility form that reads stored procedure parameter information and generates the required code for using this sp through ADO. This after constant run-ins with syntax and data type mismatch errors.
>
>I got the idea from reading "Professional ASP 3.0" from Wrox press. I wrote this in the spur of the moment (If I think about it too much I may end up not doing it) so I'm sure there's room for more niceties.
>
>The form was tested using SQL Server 7.0. If you find that it also works with other data stores please let me know!
>
>Feel free to make comments or suggestions. Look for it soon on your local Files Section under Win32API and other API's.