Wednesday, November 30, 2022
Code Search
Code Bank
.NET Applications
XSD Schema Generator
.NET/XML Training


Automating Stored Procedure Parameters with XML

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.

Teaches ASP.NET, C#, XML, XmlTextReader
Requirements .NET 1.0
Example: Click Here
View Source Code: Click Here
Download Code: Click Here


.NET, SharePoint and Silverlight Training Solutions
    Online, Onsite and Video Training on .NET and SharePoint technologies available through The Wahlin Group.

© 2007 Wahlin Consulting LLC
XML for ASP.NET Developers in bookstores