SqlCeParameter.Precision Property

Article
10/22/2009

Gets or sets the maximum number of digits used to represent the Value property.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Property Precision As Byte

public byte Precision { get; set; }

public:
property unsigned char Precision {
    unsigned char get ();
    void set (unsigned char value);
}

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

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

public function get Precision () : byte

public function set Precision (value : byte)

Property Value

The maximum number of digits used to represent the Value property. The default value is 0.

Remarks

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

Example

The following example creates a SqlCeParameter and sets the Precision 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

Share via