In an app I'm developing, I'm using stored procedures to update and create new records for a table.
There are lots and lots of columns in this table and it will grow as the app matures.
I'm creating the command to call to the stored procedure and adding the parameters, one by one.
That's a LOT of typing.

Looking at Bonnie's blog, I found some code that will generate the parameters and values for me.
Will that work if the generated parameters are not in the same sequence as they are declared in the stored procedure?

Any other ideas to cut down on the typing?