dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2ParameterCollection Class / Add Method / Add(String,DB2Type,Int32) Method
The name of the parameter.
One of the DB2Type values.
The maximum size, in bytes, of the data the parameter can contain.
Example

In This Topic
    Add(String,DB2Type,Int32) Method
    In This Topic
    Adds a DB2Parameter to the DB2ParameterCollection given the the parameter name, data type, and data size.
    Syntax
    'Declaration
     
    Public Overloads Function Add( _
       ByVal parameterName As String, _
       ByVal dbType As DB2Type, _
       ByVal size As Integer _
    ) As DB2Parameter
    public DB2Parameter Add( 
       string parameterName,
       DB2Type dbType,
       int size
    )

    Parameters

    parameterName
    The name of the parameter.
    dbType
    One of the DB2Type values.
    size
    The maximum size, in bytes, of the data the parameter can contain.

    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.
    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);
    }
    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)
    End Sub
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also