DB2ParameterCollection.Add (String, DB2Type) Method

Syntax

[Visual Basic]
Overloads Public Function Add( _
   ByVal parameterName As String, _
   ByVal DB2Type As DB2Type
 _
) As DB2Parameter

[C#]
public DB2Parameter
 Add(
   string parameterName,
   DB2Type
 DB2Type
);
[C++]
public: DB2Parameter
* Add(
   String* parameterName,
   DB2Type
 DB2Type
);
[JScript]
public function Add(
   parameterName : String,
   DB2Type : DB2Type

) : DB2Parameter
;

Parameters

parameterName

The name of the parameter.

DB2Type

One of the DB2®Type values.

Return value

The new DB2Parameter object.

Example

[Visual Basic, C#] The following example creates a DB2ParameterCollection , adds an instance of DB2Parameter to the collection, and returns a reference to the new DB2Parameter.

[Visual Basic]
Public Function CreateDB2ParamColl(myConn As DB2Connection) As DB2Parameter
    Dim myCommand As DB2Command = New DB2Command(
      "SELECT * FROM EMPLOYEE WHERE EMPNO = ?", myConn) 
    Dim myParamCollection As DB2ParameterCollection = myCommand.Parameters 
    Dim myParm As DB2Parameter = myParamCollection.Add("EMPNO", DB2Type.VarChar)

    Return myParm
End Function 'CreateDB2ParamColl

[C#]
public DB2Parameter CreateDB2ParamColl(DB2Connection myConn) {
    DB2Command myCommand = new DB2Command(
      "SELECT * FROM EMPLOYEE WHERE EMPNO = ?", myConn);
    DB2ParameterCollection myParamCollection = myCommand.Parameters;
    DB2Parameter myParm = myParamCollection.Add("EMPNO", DB2Type.VarChar);

    return myParm;
 }