SqlCeParameter.Precision Property

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)
Not applicable.

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;

Platforms

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.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeParameter Class
SqlCeParameter Members
System.Data.SqlServerCe Namespace
Scale
Size