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 OracleParameter Add(
	string parameterName,
	OracleType dataType
)

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 void CreateOracleParamColl() {
    OracleCommand command = new OracleCommand( 
        "SELECT Ename, DeptNo FROM Emp WHERE EmpNo = :pEmpNo", connection);
    OracleParameterCollection paramCollection = command.Parameters;
    object parameter = new OracleParameter("pEmpNo", OracleType.Number);
    int pIndex = paramCollection.Add(parameter);
 }

.NET Framework
Available since 1.1
Return to top
Show: