C# - The SqlParameter Class

The SqlParameter class is used to pass parameters to a stored procedure in a SQL database.

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";