SqlParameter Constructor (String, SqlDbType)

SqlParameter Constructor (String, SqlDbType)

 

Initializes a new instance of the SqlParameter class that uses the parameter name and the data type.

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

public SqlParameter(
	string parameterName,
	SqlDbType dbType
)

Parameters

parameterName
Type: System.String

The name of the parameter to map.

dbType
Type: System.Data.SqlDbType

One of the SqlDbType values.

Exception Condition
ArgumentException

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

The data type and, if appropriate, Size and Precision are inferred from the value of the dbType parameter.

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

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

    command.Parameters.Add(parameter);
}

.NET Framework
Available since 1.1
Return to top
Show:
© 2016 Microsoft