Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Add Method (String, SqlDbType)

SqlParameterCollection.Add Method (String, SqlDbType)

Adds a SqlParameter to the SqlParameterCollection given the parameter name and the data type.

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

public SqlParameter Add(
	string parameterName,
	SqlDbType sqlDbType
)

Parameters

parameterName
Type: System.String

The name of the parameter.

sqlDbType
Type: System.Data.SqlDbType

One of the SqlDbType values.

Return Value

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

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

.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