Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Add Method (OracleParameter)

OracleParameterCollection.Add Method (OracleParameter)

Adds the specified OracleParameter to the OracleParameterCollection.

Namespace:  System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

'Declaration
Public Function Add ( _
	value As OracleParameter _
) As OracleParameter

Parameters

value
Type: System.Data.OracleClient.OracleParameter

The OracleParameter to add to the collection.

Return Value

Type: System.Data.OracleClient.OracleParameter
A reference to the new OracleParameter object.

ExceptionCondition
ArgumentException

The OracleParameter specified in the value parameter is already added to this or another OracleParameterCollection.

ArgumentNullException

The value parameter is null.

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

Public Sub CreateOracleParamColl(connection As OracleConnection)
  Dim command As OracleCommand = New OracleCommand( _
    "SELECT Ename, DeptNo FROM Emp WHERE EmpNo = :pEmpNo", connection)
  Dim paramCollection As OracleParameterCollection = command.Parameters
  Dim parameter As Object = New OracleParameter("pEmpNo", OracleType.Number)
  Dim pIndex As Integer = paramCollection.Add(parameter)
End Sub

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1
Show:
© 2015 Microsoft