Add Method (String, OracleType, Int32)

OracleParameterCollection.Add Method (String, OracleType, Int32)

 

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

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

public OracleParameter Add(
	string parameterName,
	OracleType dataType,
	int size
)

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.

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

.NET Framework
Available since 1.1
Return to top
Show:
© 2016 Microsoft