SqlCeParameter.Scale Property

Article
10/22/2009

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

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)

Property Value

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.

Example

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;

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
Version Information
.NET Framework and NET Compact Framework
Supported in 3.5
.NET Framework
Supported in 3.0
.NET Compact Framework and .Net Framework
Supported in 2.0