Add(String,DB2Type) Method

On this page

Adds a DB2Parameter to the DB2ParameterCollection given the parameter name and data type.

Syntax

Visual Basic
C#


'Declaration Public Overloads Function Add( _ ByVal parameterName As String, _ ByVal type As DB2Type _ ) As DB2Parameter


public DB2Parameter Add( string parameterName, DB2Type type )

Parameters

parameterName: The name of the parameter.
type: One of the DB2Type values.

Return Value

The new DB2Parameter object.

Example

The following example creates a DB2ParameterCollection, adds instances of DB2Parameter to the collection, and returns a reference to the new DB2Parameter.

csharp


public void CreateDB2ParamColl(DB2Connection myConn) { DB2Command db2Command = new DB2Command("SELECT * FROM Dept WHERE DeptNo = :DeptNo", myConn); DB2ParameterCollection myParamCollection = db2Command.Parameters; object myParm = new DB2Parameter("DeptNo", DB2Type.Int); int pIndex = myParamCollection.Add(myParm); }

public void CreateDB2ParamColl(DB2Connection myConn) {
  DB2Command db2Command = new DB2Command("SELECT * FROM Dept WHERE DeptNo = :DeptNo", myConn);
  DB2ParameterCollection myParamCollection = db2Command.Parameters;
  object myParm = new DB2Parameter("DeptNo", DB2Type.Int);
  int pIndex = myParamCollection.Add(myParm);
}

Visual Basic


Public Sub CreateDB2ParamColl(myConn As DB2Connection) Dim db2Command As DB2Command = New DB2Command("SELECT * FROM Dept WHERE DeptNo = :DeptNo", myConn) Dim myParamCollection As DB2ParameterCollection = db2Command.Parameters Dim myParm As Object = New DB2Parameter("DeptNo", DB2Type.Int) Dim pIndex As Integer = myParamCollection.Add(myParm) End Sub

Public Sub CreateDB2ParamColl(myConn As DB2Connection)
  Dim db2Command As DB2Command = New DB2Command("SELECT * FROM Dept WHERE DeptNo = :DeptNo", myConn)
  Dim myParamCollection As DB2ParameterCollection = db2Command.Parameters
  Dim myParm As Object = New DB2Parameter("DeptNo", DB2Type.Int)
  Dim pIndex As Integer = myParamCollection.Add(myParm)
End Sub

Reference

DB2ParameterCollection Class
DB2ParameterCollection Members
Overload List

Send Feedback