Running Stored Procedures with ASP.NET

In this article, you’ll learn how to extract a list of stored procedures from a database, plus information about the parameters associated with the stored procedure. Finally, you’ll see how to take this information and use it to call a stored procedure on the fly.

http://sqljunkies.com/Tutorial/4EC83A05-37CA-479D-94D9-04EAFE7705F9.scuk