Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SqlParameterCollection.Add Method (String, SqlDbType, Int32)

Adds a SqlParameter to the SqlParameterCollection, given the specified parameter name, SqlDbType and size.

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

public SqlParameter Add(
	string parameterName,
	SqlDbType sqlDbType,
	int size
)

Parameters

parameterName
Type: System.String

The name of the parameter.

sqlDbType
Type: System.Data.SqlDbType

The SqlDbType of the SqlParameter to add to the collection.

size
Type: System.Int32

The size as an Int32.

Return Value

Type: System.Data.SqlClient.SqlParameter
A new SqlParameter object.

This overload is useful when you are adding a parameter of a variable-length data type such as varchar or binary.

public void AddSqlParameter(SqlCommand command) 
{
    SqlParameter param = new SqlParameter(
        "@Description", SqlDbType.NVarChar, 16);
    param.Value = "Beverages";
    command.Parameters.Add(param);
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft