.NET Framework Class Library  

SqlDecimal Members

SqlDecimal overview

Public Constructors

public constructorSqlDecimal Constructor

Supported by the .NET Compact Framework.

Overloaded. Initializes a new instance of the SqlDecimal structure.

Public Fields

public fieldstatic (Shared in Visual Basic)MaxPrecision

Supported by the .NET Compact Framework.

A constant representing the largest possible value for the Precision property.
public fieldstatic (Shared in Visual Basic)MaxScale

Supported by the .NET Compact Framework.

A constant representing the maximum value for the Scale property.
public fieldstatic (Shared in Visual Basic)MaxValue

Supported by the .NET Compact Framework.

A constant representing the maximum value of a SqlDecimal structure.
public fieldstatic (Shared in Visual Basic)MinValue

Supported by the .NET Compact Framework.

A constant representing the minimum value for a SqlDecimal structure.
public fieldstatic (Shared in Visual Basic)Null

Supported by the .NET Compact Framework.

Represents a null value that can be assigned to the Value property of an instance of the SqlMoney class.

Public Properties

public propertyBinData

Supported by the .NET Compact Framework.

Get the binary representation of the value of this SqlDecimal structure as an array of bytes.
public propertyData

Supported by the .NET Compact Framework.

Gets the binary representation of this SqlDecimal structure as an array of integers.
public propertyIsNull

Supported by the .NET Compact Framework.

Indicates whether or not the Value of this SqlDecimal structure is null.
public propertyIsPositive

Supported by the .NET Compact Framework.

Indicates whether or not the Value of this SqlDecimal structure is greater than zero.
public propertyPrecision

Supported by the .NET Compact Framework.

Gets or sets the maximum number of digits used to represent the Value property.
public propertyScale

Supported by the .NET Compact Framework.

Gets or sets the number of decimal places to which Value is resolved.
public propertyValue

Supported by the .NET Compact Framework.

Gets the value of the SqlDecimal structure. This property is read-only.

Public Methods

public methodstatic (Shared in Visual Basic)Abs

Supported by the .NET Compact Framework.

The Abs member function gets the absolute value of the SqlDecimal parameter.
public methodstatic (Shared in Visual Basic)Add

Supported by the .NET Compact Framework.

Calculates the sum of the two SqlDecimal operators.
public methodstatic (Shared in Visual Basic)AdjustScale

Supported by the .NET Compact Framework.

The scale of the SqlDecimal operand will be adjusted to the number of digits indicated by the digits parameter. Depending on the value of the fRound parameter, the value will either be rounded to the appropriate number of digits or truncated.
public methodstatic (Shared in Visual Basic)Ceiling

Supported by the .NET Compact Framework.

Returns the smallest whole number greater than or equal to the specified SqlDecimal structure.
public methodCompareTo

Supported by the .NET Compact Framework.

Compares this instance to the supplied object and returns an indication of their relative values.
public methodstatic (Shared in Visual Basic)ConvertToPrecScale

Supported by the .NET Compact Framework.

Adjusts the value of the SqlDecimal operand to the indicated precision and scale.
public methodstatic (Shared in Visual Basic)Divide

Supported by the .NET Compact Framework.

The division operator calculates the results of dividing the first SqlDecimal operand by the second.
public methodEquals

Supported by the .NET Compact Framework.

Overloaded.
public methodstatic (Shared in Visual Basic)Floor

Supported by the .NET Compact Framework.

Rounds a specified SqlDecimal number to the next lower whole number.
public methodGetHashCode

Supported by the .NET Compact Framework.

Overridden. Returns the hash code for this instance.
public methodGetType (inherited from Object)

Supported by the .NET Compact Framework.

Gets the Type of the current instance.
public methodstatic (Shared in Visual Basic)GreaterThan

Supported by the .NET Compact Framework.

Performs a logical comparison of two SqlDecimal structures to determine if the first is greater than the second.
public methodstatic (Shared in Visual Basic)GreaterThanOrEqual

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlDecimal parameters to determine if the first is greater than or equal to the second.
public methodstatic (Shared in Visual Basic)LessThan

Supported by the .NET Compact Framework.

Performs a logical comparison of two SqlDecimal structures to determine if the first is less than the second.
public methodstatic (Shared in Visual Basic)LessThanOrEqual

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlDecimal parameters to determine if the first is less than or equal to the second.
public methodstatic (Shared in Visual Basic)Multiply

Supported by the .NET Compact Framework.

The multiplication operator computes the product of the two SqlDecimal parameters.
public methodstatic (Shared in Visual Basic)NotEquals

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlDecimal parameters to determine if they are not equal.
public methodstatic (Shared in Visual Basic)Parse

Supported by the .NET Compact Framework.

Converts the String representation of a number to its SqlDecimal equivalent.
public methodstatic (Shared in Visual Basic)Power

Supported by the .NET Compact Framework.

Raises the value of the specified SqlDecimal structure to the specified exponential power.
public methodstatic (Shared in Visual Basic)Round

Supported by the .NET Compact Framework.

Gets the number nearest the specified SqlDecimal structure's value with the specified precision.
public methodstatic (Shared in Visual Basic)Sign

Supported by the .NET Compact Framework.

Gets a value indicating the sign of a SqlDecimal structure's Value property.
public methodstatic (Shared in Visual Basic)Subtract

Supported by the .NET Compact Framework.

Calculates the results of subtracting the second SqlDecimal operand from the first.
public methodToDouble

Supported by the .NET Compact Framework.

Returns the a double equal to the contents of the Value property of this instance.
public methodToSqlBoolean

Supported by the .NET Compact Framework.

Converts this SqlDecimal structure to SqlBoolean.
public methodToSqlByte

Supported by the .NET Compact Framework.

Converts this SqlDecimal structure to SqlByte.
public methodToSqlDouble

Supported by the .NET Compact Framework.

Converts this SqlDecimal structure to SqlDouble.
public methodToSqlInt16

Supported by the .NET Compact Framework.

Converts this SqlDecimal structure to SqlInt16.
public methodToSqlInt32

Supported by the .NET Compact Framework.

Converts this SqlDecimal structure to SqlInt32.
public methodToSqlInt64

Supported by the .NET Compact Framework.

Converts this SqlDecimal structure to SqlInt64.
public methodToSqlMoney

Supported by the .NET Compact Framework.

Converts this SqlDecimal structure to SqlMoney.
public methodToSqlSingle

Supported by the .NET Compact Framework.

Converts this SqlDecimal structure to SqlSingle.
public methodToSqlString

Supported by the .NET Compact Framework.

Converts this SqlDecimal structure to SqlString.
public methodToString

Supported by the .NET Compact Framework.

Overridden. Converts this SqlDecimal structure to String.
public methodstatic (Shared in Visual Basic)Truncate

Supported by the .NET Compact Framework.

Truncates the specified SqlDecimal structure's value to the desired position.

Public Operators and Type Conversions

public operatorstatic (Shared in Visual Basic)Addition Operator

Supported by the .NET Compact Framework.

Calculates the sum of the two SqlDecimal operators.
public operatorstatic (Shared in Visual Basic)Division Operator

Supported by the .NET Compact Framework.

The division operator calculates the results of dividing the first SqlDecimal operand by the second.
public operatorstatic (Shared in Visual Basic)Equality Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlDecimal operands to determine if they are equal.
public operatorstatic (Shared in Visual Basic)Greater Than Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of two SqlDecimal structures to determine if the first is greater than the second.
public operatorstatic (Shared in Visual Basic)Greater Than Or Equal Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlDecimal parameters to determine if the first is greater than or equal to the second.
public operatorstatic (Shared in Visual Basic)Inequality Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlDecimal parameters to determine if they are not equal.
public operatorstatic (Shared in Visual Basic)Less Than Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of two SqlDecimal structures to determine if the first is less than the second.
public operatorstatic (Shared in Visual Basic)Less Than Or Equal Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlDecimal parameters to determine if the first is less than or equal to the second.
public operatorstatic (Shared in Visual Basic)Multiplication Operator

Supported by the .NET Compact Framework.

The multiplication operator computes the product of the two SqlDecimal parameters.
public operatorstatic (Shared in Visual Basic)Subtraction Operator

Supported by the .NET Compact Framework.

Calculates the results of subtracting the second SqlDecimal operand from the first.
public operatorstatic (Shared in Visual Basic)Unary Negation Operator

Supported by the .NET Compact Framework.

The unary minus operator negates the SqlDecimal parameter.
public operatorstatic (Shared in Visual Basic)SqlBoolean to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the supplied SqlBoolean structure to SqlDecimal.
public operatorstatic (Shared in Visual Basic)SqlDecimal to Decimal Conversion

Supported by the .NET Compact Framework.

Converts the SqlDecimal parameter to Decimal.
public operatorstatic (Shared in Visual Basic)SqlDouble to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the supplied SqlDouble structure to SqlDecimal.
public operatorstatic (Shared in Visual Basic)SqlSingle to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the supplied SqlSingle structure to SqlDecimal.
public operatorstatic (Shared in Visual Basic)SqlString to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the supplied SqlString parameter to SqlDecimal.
public operatorstatic (Shared in Visual Basic)Decimal to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the Decimal value to SqlDecimal.
public operatorstatic (Shared in Visual Basic)SqlByte to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the supplied SqlByte structure to SqlDecimal.
public operatorstatic (Shared in Visual Basic)SqlInt16 to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the supplied SqlInt16 structure to SqlDecimal
public operatorstatic (Shared in Visual Basic)SqlInt32 to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the supplied SqlInt32 structure to SqlDecimal.
public operatorstatic (Shared in Visual Basic)SqlInt64 to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the supplied SqlInt64 structure to SqlDecimal.
public operatorstatic (Shared in Visual Basic)SqlMoney to SqlDecimal Conversion

Supported by the .NET Compact Framework.

Converts the SqlMoney operand to SqlDecimal.

Protected Methods

protected methodFinalize (inherited from Object)

Supported by the .NET Compact Framework.

Overridden. Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

In C# and C++, finalizers are expressed using destructor syntax.

protected methodMemberwiseClone (inherited from Object)

Supported by the .NET Compact Framework.

Creates a shallow copy of the current Object.

See Also

SqlDecimal Structure | System.Data.SqlTypes Namespace