This topic has not yet been rated - Rate this topic

SqlCeDataReader.GetDecimal Method

Visual Studio 2010

Other Versions

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

C++

JScript

Copy

public override decimal GetDecimal(
	int ordinal
)

Parameters

ordinal: Type: System.Int32
The zero-based column ordinal.

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 null.
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.

Reference

SqlCeDataReader Class

System.Data.SqlServerCe Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)