OracleParameterCollection.Add Method (String, OracleType)

 

Adds an OracleParameter to the OracleParameterCollection given the parameter name and data type.

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

Public Function Add (
	parameterName As String,
	dataType As OracleType
) As OracleParameter

Parameters

parameterName
Type: System.String

The name of the parameter.

dataType
Type: System.Data.OracleClient.OracleType

One of the OracleType values.

Return Value

Type: System.Data.OracleClient.OracleParameter

A reference to the new OracleParameter object.

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
Available since 1.1
Return to top
Show: