OdbcParameterCollection.Add Method (String, Object)

Note: This API is now obsolete.

Adds an OdbcParameter to the OdbcParameterCollection given the parameter name and value.

Namespace:   System.Data.Odbc
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", 
public OdbcParameter Add(
	string parameterName,
	object value


Type: System.String

The name of the parameter.

Type: System.Object

The Value of the OdbcParameter to add to the collection.

Return Value

Type: System.Data.Odbc.OdbcParameter

The index of the new OdbcParameter object.

Exception Condition

The value parameter is not an OdbcParameter.

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

.NET Framework
Available since 1.1
Return to top