Export (0) Print
Expand All

OracleParameterCollection.Add Method (String, OracleType, Int32, String)

Adds an OracleParameter to the OracleParameterCollection given the parameter name, data type, column length, and source column name.

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

'Declaration
Public Function Add ( _
	parameterName As String, _
	dataType As OracleType, _
	size As Integer, _
	srcColumn As String _
) As OracleParameter

Parameters

parameterName
Type: System.String

The name of the parameter.

dataType
Type: System.Data.OracleClient.OracleType

One of the OracleType values.

size
Type: System.Int32

The length of the column.

srcColumn
Type: System.String

The name of the source column.

Return Value

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

The following example creates an OracleParameterCollection, adds an instance 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 OracleParameter = _
    paramCollection.Add("pEmpNo", OracleType.Number, 5, "EmpNo")
End Sub

.NET Framework

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