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
'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);
}

/** @property */
public byte get_Scale ()

/** @property */
public void set_Scale (byte value)

public function get Scale () : byte

public function set Scale (value : byte)

Not applicable.

The number of decimal places to which Value is resolved. The default is 0.

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

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;

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.