Properties of the SqlParameter Class

Item	Description
Properties
DbType	Contains the data type of the SQL parameter
Direction	Defines whether the parameter is input or output
IsNullable	Defines whether the parameter can be null
ParameterName	Contains the name of the parameter
Precision	Contains the precision of the parameter
Scale	Contains the scale of the parameter
Size	Contains the size of the parameter
Value	Contains the value of the parameter

SqlParameter.DbType

Syntax

SqlDbType DbType

Description

The DbType property is set to the SQL data type that is expected by the stored procedure. Any of the values in the System.Data.SqlClient.SqlDbType namespace are acceptable.

Example

SqlParameter param = new SqlParameter();

param.DbType = SqlDbType.NVarChar;

SqlParameter.Direction

Syntax

ParameterDirection Direction

Description

The Direction property sets the direction of the parameter and should match the stored procedure. Acceptable values for this property are found in the System.Data.SqlClient.ParameterDirection namespace.

Example

SqlParameter param = new SqlParameter();

param.Direction = ParameterDirection.Input;

SqlParameter.IsNullable

Syntax

Boolean IsNullable

Description

The IsNullable property specifies whether the parameter is allowed to be null.

Example

SqlParameter param = new SqlParameter();


param.IsNullable = true;

SqlParameter.ParameterName

Syntax

String ParameterName

Description

The ParameterName property specifies the name of the parameter that the stored procedure is expecting.

Example

param.ParameterName = "@ProductID";

SqlParameter.Precision

Syntax

Byte Precision

Description

The Precision property is used to specify the number of digits used to represent the value of the parameter.

Example

SqlParameter param = new SqlParameter();
param.Precision = 2;

SqlParameter.Scale

Syntax

Byte Scale

Description

The Scale property is used to specify the number of decimal places in the value of the parameter.

Example

SqlParameter param = new SqlParameter();
param.Scale = 2;

SqlParameter.Size

Syntax

Int32 Size

Description

The Size property specifies the size of the parameter that the stored procedure is expecting.

Example

SqlParameter param = new SqlParameter();
param.Size = 7;

SqlParameter.Value

Syntax

Object Value

Description

The Value property is used to specify the value of the parameter that will be passed to the stored procedure.

Example

SqlParameter param = new SqlParameter();
param.Value = "Test";