Dealing with parameters in Stored Procedures is often a laborious and time intensive process. This example shows how the process can be simplified using XML as a vehicle for storing stored procedure parameter details.

The sample application includes a class named "SprocParameterGenerator" which generates SqlCommand or OleDbCommand objects and fills them with the proper parameters for a given stored procedure. The class uses the XmlTextReader to read parameter information from an XML document named "SprocParameters.config" and minimizes the amount of code that needs to be written. To see the application in action or view the source code, select one of the links below.