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)

public override decimal GetDecimal (
	int ordinal
public Decimal GetDecimal (
	int ordinal
public override function GetDecimal (
	ordinal : int
) : decimal
Not applicable.



The zero-based column ordinal.

Return Value

The value of the specified column.

Exception typeCondition


The specified cast is not valid.


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


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

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

The maximum size of the SQL Server Compact Edition 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.

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.

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions