The SQLCommandBuilder has the helpful DeriveParameters command that gives you the list of parameters of a stored procedure. All you have to do is:
- Set the commandText of the command object to the StoredProcedure Name
- Set the CommandType of the command object to “StoredProcedure”
- Use the SqlCommandBuilder’s DeriveParameters command to retrieve the list of parameters.
Code sample:
SqlCommand myCommand; myCommand.CommandType = CommandType.StoredProcedure; myCommand.CommandText = storedProcedureName; ...SqlCommandBuilder.DeriveParameters(myCommand);
Use the Command’s parameters list to retrieve them.