Add(String,OracleDbType,ParameterDirection) Method

In This Topic

Syntax
Example
See Also

Adds a OracleParameter to the OracleParameterCollection given the parameter name, data type, and direction.

Syntax

Visual Basic
C#

public OracleParameter Add( 
   string parameterName,
   OracleDbType dbType,
   ParameterDirection direction
)

'Declaration
 
Public Overloads Function Add( _
   ByVal parameterName As String, _
   ByVal dbType As OracleDbType, _
   ByVal direction As ParameterDirection _
) As OracleParameter

Parameters

parameterName: The name of the parameter.
dbType: One of the OracleDbType values.
direction: Specifies whether the parameter is input, output, both, or it is the return value.

Return Value

The new OracleParameter object.

Example

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

csharp

public void CreateOracleParamColl(OracleConnection myConn) {
  OracleCommand myCommand = new OracleCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn);
  OracleParameterCollection myParamCollection = myCommand.Parameters;
  object myParm = new OracleParameter("DeptNo", OracleDbType.Integer);
  int pIndex = myParamCollection.Add(myParm);
}

Visual Basic

Public Sub CreateOracleParamColl(myConn As OracleConnection)
  Dim myCommand As OracleCommand = New OracleCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn)
  Dim myParamCollection As OracleParameterCollection = myCommand.Parameters
  Dim myParm As Object = New OracleParameter("DeptNo", OracleDbType.Integer)
  Dim pIndex As Integer = myParamCollection.Add(myParm)
End Sub

Reference

OracleParameterCollection Class
OracleParameterCollection Members
Overload List

Send Feedback