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)
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); }
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
