SqlCeParameter.Precision Property

Article
10/22/2007

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
'Usage
Dim instance As SqlCeParameter
Dim value As Byte

value = instance.Precision

instance.Precision = value

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;

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .

Platforms

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

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

Version Information

.NET Compact Framework

Supported in: 2.0, 1.0