Chapter 20. The Parameter Class

The Parameter class works with the Command class to execute parameterized commands or call stored procedures. Every Command object exposes a Parameters collection. In this collection, there is one Parameter object for every input and output parameter, and an additional Parameter object to represent a return value, if required.

The Parameter object can also define a mapping between parameters and columns in a DataSet. This allows a column value to be submitted (copied from the DataSet into an input parameter) and refreshed (copied from an output parameter or return value into the DataSet) automatically when using the Update( ) method of the DataAdapter.