Consider that I have a table like this:



ColumnName: Stored Procedure Name

InsertRecord

DeleteRecord

UpdateRecord



What I want to be able to do is iterate through the table and execute the stored procedures at run time. The stored procedures though have a different number of parameters. InsertRecord has only one parameter, while DeleteRecord has two, etc.



How could I do this in code? Obviously I dont want to have to hard code the parameters in the VB code.



Should I use the DeriveParameters command? What would be the best way to execute these stored procedures when the parameters are unknown?



Thanks :-D