Add(String,DB2Type,Int32,String) Method

In This Topic

Syntax
Example
See Also

Adds a DB2Parameter to the DB2ParameterCollection given the parameter name, data type, column width, and source column name.

Syntax

Visual Basic
C#

public DB2Parameter Add( 
   string parameterName,
   DB2Type dbType,
   int size,
   string sourceColumn
)

'Declaration
 
Public Overloads Function Add( _
   ByVal parameterName As String, _
   ByVal dbType As DB2Type, _
   ByVal size As Integer, _
   ByVal sourceColumn As String _
) As DB2Parameter

Parameters

parameterName: The name of the parameter.
dbType
size: The maximum size, in bytes, of the data the parameter can contain.
sourceColumn: The name of the source column.

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;
  DB2Parameter myNewParameter = myParamCollection.Add("DeptNo", DB2Type.Int, 40, "DeptNo");
}

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 myNewParameter As DB2Parameter = myParamCollection.Add("DeptNo", DB2Type.Int, 40, "DeptNo")
End Sub

Reference

DB2ParameterCollection Class
DB2ParameterCollection Members
Overload List

Send Feedback