I have an application I wrote that generates the "data layer" VB code from a SQL-2000 stored procedure. It make life much, much simpler. Right now the application is only helpful for Inserts SPs and Update SPs (Not too good for Selects or Deletes), but it may help solve your current problem. Below is a link to the application in case you are interested.
