Export (0) Print
Expand All

SqlParameter Constructor (String, SqlDbType, Int32, String)

Initializes a new instance of the SqlParameter class that uses the parameter name, the SqlDbType, the size, and the source column name.

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

public SqlParameter(
	string parameterName,
	SqlDbType dbType,
	int size,
	string sourceColumn
)

Parameters

parameterName
Type: System.String

The name of the parameter to map.

dbType
Type: System.Data.SqlDbType

One of the SqlDbType values.

size
Type: System.Int32

The length of the parameter.

sourceColumn
Type: System.String

The name of the source column (SourceColumn) if this SqlParameter is used in a call to Update.

ExceptionCondition
ArgumentException

The value supplied in the dbType parameter is an invalid back-end data type.

The Size is inferred from the value of the dbType parameter if it is not explicitly set in the size parameter.

The following example creates a SqlParameter and sets some of its properties.

private static void AddSqlParameter(SqlCommand command)
{
    SqlParameter parameter = new SqlParameter("@Description", 
        SqlDbType.VarChar, 88, "Description");
    parameter.IsNullable = true;
    parameter.Direction = ParameterDirection.Output;

    command.Parameters.Add(parameter);
}

.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