0
kicks
Retrieve sproc parameters with SqlCommandBuilder.DeriveParameters Meth
Stop hard coding your stored procedure paramters. Here's how to dynamically retrieve the parameters for any stored procedure using SqlCommandBuilder.DeriveParameters.