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.
|