Export (0) Print
Expand All

OracleParameterCollection.Add Method (String, Object)

NOTE: This method is now obsolete.

Adds an OracleParameter to the OracleParameterCollection given the parameter name and value.

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in system.data.oracleclient.dll)

[ObsoleteAttribute(L"Add(String parameterName, Object value) has been deprecated.  Use AddWithValue(String parameterName, Object value).  http://go.microsoft.com/fwlink/?linkid=14202", false)] 
public:
OracleParameter^ Add (
	String^ parameterName, 
	Object^ value
)
/** @attribute ObsoleteAttribute("Add(String parameterName, Object value) has been deprecated.  Use AddWithValue(String parameterName, Object value).  http://go.microsoft.com/fwlink/?linkid=14202", false) */ 
public OracleParameter Add (
	String parameterName, 
	Object value
)
ObsoleteAttribute("Add(String parameterName, Object value) has been deprecated.  Use AddWithValue(String parameterName, Object value).  http://go.microsoft.com/fwlink/?linkid=14202", false) 
public function Add (
	parameterName : String, 
	value : Object
) : OracleParameter

Parameters

parameterName

The name of the parameter.

value

The .Data.OracleClient.OracleParameter.Value of the OracleParameter to add to the collection.

Return Value

The index of the new OracleParameter object.

Exception typeCondition

InvalidCastException

The value parameter is not an OracleParameter.

Use caution when using this overload of the Add method to specify integer parameter values. Because this overload takes a value of type Object, you must convert the integral value to an Object type when the value is zero, as the following C# example demonstrates.

parameters.Add("pname", Convert.ToInt32(0));

If you do not perform this conversion, the compiler will assume you are attempting to call the OracleParameterCollection.Add (string, OracleType) overload.

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 1.1
Obsolete (compiler warning) in 2.0

Community Additions

ADD
Show:
© 2014 Microsoft