Share via


SqlCeDataReader.GetDecimal Method

Gets the value of the specified column as a Decimal object.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

Syntax

'Declaration
Public Overrides Function GetDecimal ( _
    ordinal As Integer _
) As Decimal
'Usage
Dim instance As SqlCeDataReader
Dim ordinal As Integer
Dim returnValue As Decimal

returnValue = instance.GetDecimal(ordinal)
public override decimal GetDecimal(
    int ordinal
)
public:
virtual Decimal GetDecimal(
    int ordinal
) override
abstract GetDecimal : 
        ordinal:int -> decimal 
override GetDecimal : 
        ordinal:int -> decimal 
public override function GetDecimal(
    ordinal : int
) : decimal

Parameters

Return Value

Type: System.Decimal
The value of the specified column.

Implements

IDataRecord.GetDecimal(Int32)

Exceptions

Exception Condition
InvalidCastException

The specified cast is not valid.

SqlNullValueException

The value is nulla null reference (Nothing in Visual Basic).

InvalidOperationException

The operation is not valid. The SqlCeDataReader may be positioned after the last row in the result set.

Remarks

No conversions are performed; therefore, the data retrieved must already be a Decimal object.

The maximum size of the SQL Server Compact decimal is greater than the maximum size of Decimal. For example, an overflow can occur when SqlCeDataReader is reading values that are either greater than Decimal.MaxValue or lesser than Decimal.MinValue.

Call IsDBNull to check for null values before calling this method.

See Also

Reference

SqlCeDataReader Class

System.Data.SqlServerCe Namespace