John Tobler's somewhat ordered collection of thoughts and resources mostly related to software architecture and software engineering.
Microsoft Knowledge Base Article - 165156
HOWTO: Determine Parameter Requirements for a Stored Procedure in ASP
I'd point you to SqlCommandBuilder.DeriveParameters() or OleDbCommandBuilder.DeriveParameters() to do the same in .NET.
Take a look at the CommandBuilder DerivedParameters. Although this does require a db trip, it works very nice.