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

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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)

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

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 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, 5, "EmpNo");
}

.NET Framework
Available since 1.1
Return to top
Show: