The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.
SqlParameterCollection::Add Method (String^, Object^)
.NET Framework (current version)
Note: This API is now obsolete.
Namespace:
System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)
Return to top
Adds the specified SqlParameter object to the SqlParameterCollection.
Assembly: System.Data (in System.Data.dll)
public: [ObsoleteAttribute("Add(String parameterName, Object value) has been deprecated. Use AddWithValue(String parameterName, Object value). http://go.microsoft.com/fwlink/?linkid=14202", false)] SqlParameter^ Add( String^ parameterName, Object^ value )
Parameters
- parameterName
-
Type:
System::String^
The name of the SqlParameter to add to the collection.
- value
-
Type:
System::Object^
A Object.
Return Value
Type: System.Data.SqlClient::SqlParameter^A new SqlParameter object.
Use caution when you are using this overload of the SqlParameterCollection.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 assumes that you are trying to call the SqlParameterCollection.Add (string, SqlDbType) overload.
| Exception | Condition |
|---|---|
| ArgumentException | The SqlParameter specified in the value parameter is already added to this or another SqlParameterCollection. |
| ArgumentNullException | The value parameter is null. |
.NET Framework
Available since 1.1
Available since 1.1
Show: