SqlCeParameter.Scale Property

Gets or sets the number of decimal places to which Value is resolved.

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

Syntax

'Declaration
Public Property Scale As Byte
    Get
    Set
'Usage
Dim instance As SqlCeParameter
Dim value As Byte

value = instance.Scale

instance.Scale = value
public byte Scale { get; set; }
public:
property unsigned char Scale {
    unsigned char get ();
    void set (unsigned char value);
}
member Scale : byte with get, set
function get Scale () : byte
function set Scale (value : byte)

Property Value

Type: System.Byte
The number of decimal places to which Value is resolved. The default is 0.

Remarks

The Scale property is only used for decimal and numeric input parameters.

Examples

The following example creates a SqlCeParameter and sets the Scale property.

Dim param As New SqlCeParameter("@Price", SqlDbType.Decimal)
param.Value = 3.1416
param.Precision = 8
param.Scale = 4
SqlCeParameter param = new SqlCeParameter("@Price", SqlDbType.Decimal);
param.Value = 3.1416;
param.Precision = 8;
param.Scale = 4;

See Also

Reference

SqlCeParameter Class

System.Data.SqlServerCe Namespace

Precision

Size