Export (0) Print
Expand All

OleDbParameterCollection.Add Method (String, Object)

Note: This API is now obsolete.

Adds an OleDbParameter to the OleDbParameterCollection given the parameter name and value.

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

[ObsoleteAttribute("Add(String parameterName, Object value) has been deprecated.  Use AddWithValue(String parameterName, Object value).  http://go.microsoft.com/fwlink/?linkid=14202", 
	false)]
public OleDbParameter Add(
	string parameterName,
	Object value
)

Parameters

parameterName
Type: System.String

The name of the parameter.

value
Type: System.Object

The Value of the OleDbParameter to add to the collection.

Return Value

Type: System.Data.OleDb.OleDbParameter
The index of the new OleDbParameter object.

ExceptionCondition
InvalidCastException

The value parameter is not an OleDbParameter.

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 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 Add overload.

.NET Framework

Supported in: 1.1, 1.0
Obsolete (compiler warning) in 4.5.2
Obsolete (compiler warning) in 4.5.1
Obsolete (compiler warning) in 4.5
Obsolete (compiler warning) in 4
Obsolete (compiler warning) in 3.5
Obsolete (compiler warning) in 3.5 SP1
Obsolete (compiler warning) in 3.0
Obsolete (compiler warning) in 3.0 SP1
Obsolete (compiler warning) in 3.0 SP2
Obsolete (compiler warning) in 2.0
Obsolete (compiler warning) in 2.0 SP1
Obsolete (compiler warning) in 2.0 SP2

.NET Framework Client Profile

Obsolete (compiler warning) in 4
Obsolete (compiler warning) in 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

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

Show:
© 2014 Microsoft