Export (0) Print
Expand All

SqlDecimal Members

Represents a numeric value between - 10^38 +1 and 10^38 - 1, with fixed precision and scale.

The following tables list the members exposed by the SqlDecimal type.

  Name Description
Public method Supported by the .NET Compact Framework SqlDecimal Overloaded. Initializes a new instance of the SqlDecimal structure.
Top

  Name Description
Public field Static Supported by the .NET Compact Framework MaxPrecision A constant representing the largest possible value for the Precision property.
Public field Static Supported by the .NET Compact Framework MaxScale A constant representing the maximum value for the Scale property.
Public field Static Supported by the .NET Compact Framework MaxValue A constant representing the maximum value of a SqlDecimal structure.
Public field Static Supported by the .NET Compact Framework MinValue A constant representing the minimum value for a SqlDecimal structure.
Public field Static Supported by the .NET Compact Framework Null Represents a null value that can be assigned to the Value property of an instance of the SqlMoney class.
Top

  Name Description
Public property Supported by the .NET Compact Framework BinData Get the binary representation of the value of this SqlDecimal structure as an array of bytes.
Public property Supported by the .NET Compact Framework Data Gets the binary representation of this SqlDecimal structure as an array of integers.
Public property Supported by the .NET Compact Framework IsNull Indicates whether the Value of this SqlDecimal structure is null.
Public property Supported by the .NET Compact Framework IsPositive Indicates whether the Value of this SqlDecimal structure is greater than zero.
Public property Supported by the .NET Compact Framework Precision Gets the maximum number of digits used to represent the Value property.
Public property Supported by the .NET Compact Framework Scale Gets or sets the number of decimal places to which Value is resolved.
Public property Supported by the .NET Compact Framework Value Gets the value of the SqlDecimal structure. This property is read-only.
Top

(see also Protected Methods )
  Name Description
Public method Static Supported by the .NET Compact Framework Abs The Abs method gets the absolute value of the SqlDecimal parameter.
Public method Static Supported by the .NET Compact Framework Add Calculates the sum of the two SqlDecimal operators.
Public method Static Supported by the .NET Compact Framework AdjustScale 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 method Static Supported by the .NET Compact Framework Ceiling Returns the smallest whole number greater than or equal to the specified SqlDecimal structure.
Public method Supported by the .NET Compact Framework CompareTo Overloaded. Compares this instance to the supplied object and returns an indication of their relative values.
Public method Static Supported by the .NET Compact Framework ConvertToPrecScale Adjusts the value of the SqlDecimal operand to the indicated precision and scale.
Public method Static Supported by the .NET Compact Framework Divide The division operator calculates the results of dividing the first SqlDecimal operand by the second.
Public method Supported by the .NET Compact Framework Equals Overloaded. Overridden. Returns a value that indicates whether an instance of SqlDecimal and the supplied object parameter represent the same value.
Public method Static Supported by the .NET Compact Framework Floor Rounds a specified SqlDecimal number to the next lower whole number.
Public method Supported by the .NET Compact Framework GetHashCode Overridden. Returns the hash code for this instance.
Public method Supported by the .NET Compact Framework GetType  Gets the Type of the current instance. (Inherited from Object.)
Public method Static Supported by the .NET Compact Framework GetXsdType Returns the XML Schema definition language (XSD) of the specified XmlSchemaSet.
Public method Static Supported by the .NET Compact Framework GreaterThan Performs a logical comparison of two SqlDecimal structures to determine whether the first is greater than the second.
Public method Static Supported by the .NET Compact Framework GreaterThanOrEqual Performs a logical comparison of the two SqlDecimal parameters to determine whether the first is greater than or equal to the second.
Public method Static Supported by the .NET Compact Framework LessThan Performs a logical comparison of two SqlDecimal structures to determine whether the first is less than the second.
Public method Static Supported by the .NET Compact Framework LessThanOrEqual Performs a logical comparison of the two SqlDecimal parameters to determine whether the first is less than or equal to the second.
Public method Static Supported by the .NET Compact Framework Multiply The multiplication operator computes the product of the two SqlDecimal parameters.
Public method Static Supported by the .NET Compact Framework NotEquals Performs a logical comparison of the two SqlDecimal parameters to determine whether they are not equal.
Public method Static Supported by the .NET Compact Framework op_Addition Calculates the sum of the two SqlDecimal operators.
Public method Static Supported by the .NET Compact Framework op_Division The division operator calculates the results of dividing the first SqlDecimal operand by the second.
Public method Static Supported by the .NET Compact Framework op_Equality Performs a logical comparison of the two SqlDecimal operands to determine whether they are equal.
Public method Static Supported by the .NET Compact Framework op_Explicit Overloaded. Converts the supplied structure to SqlDecimal.
Public method Static Supported by the .NET Compact Framework op_GreaterThan Performs a logical comparison of two SqlDecimal structures to determine whether the first is greater than the second.
Public method Static Supported by the .NET Compact Framework op_GreaterThanOrEqual Performs a logical comparison of the two SqlDecimal parameters to determine whether the first is greater than or equal to the second.
Public method Static Supported by the .NET Compact Framework op_Implicit Overloaded. Converts the supplied structure to SqlDecimal.
Public method Static Supported by the .NET Compact Framework op_Inequality Performs a logical comparison of the two SqlDecimal parameters to determine whether they are not equal.
Public method Static Supported by the .NET Compact Framework op_LessThan Performs a logical comparison of two SqlDecimal structures to determine whether the first is less than the second.
Public method Static Supported by the .NET Compact Framework op_LessThanOrEqual Performs a logical comparison of the two SqlDecimal parameters to determine whether the first is less than or equal to the second.
Public method Static Supported by the .NET Compact Framework op_Multiply The multiplication operator computes the product of the two SqlDecimal parameters.
Public method Static Supported by the .NET Compact Framework op_Subtraction Calculates the results of subtracting the second SqlDecimal operand from the first.
Public method Static Supported by the .NET Compact Framework op_UnaryNegation The unary minus operator negates the SqlDecimal parameter.
Public method Static Supported by the .NET Compact Framework Parse Converts the String representation of a number to its SqlDecimal equivalent.
Public method Static Supported by the .NET Compact Framework Power Raises the value of the specified SqlDecimal structure to the specified exponential power.
Public method Static Supported by the .NET Compact Framework ReferenceEquals  Determines whether the specified Object instances are the same instance. (Inherited from Object.)
Public method Static Supported by the .NET Compact Framework Round Gets the number nearest the specified SqlDecimal structure's value with the specified precision.
Public method Static Supported by the .NET Compact Framework Sign Gets a value that indicates the sign of a SqlDecimal structure's Value property.
Public method Static Supported by the .NET Compact Framework Subtract Calculates the results of subtracting the second SqlDecimal operand from the first.
Public method Supported by the .NET Compact Framework ToDouble Returns the a double equal to the contents of the Value property of this instance.
Public method Supported by the .NET Compact Framework ToSqlBoolean Converts this SqlDecimal structure to SqlBoolean.
Public method Supported by the .NET Compact Framework ToSqlByte Converts this SqlDecimal structure to SqlByte.
Public method Supported by the .NET Compact Framework ToSqlDouble Converts this SqlDecimal structure to SqlDouble.
Public method Supported by the .NET Compact Framework ToSqlInt16 Converts this SqlDecimal structure to SqlInt16.
Public method Supported by the .NET Compact Framework ToSqlInt32 Converts this SqlDecimal structure to SqlInt32.
Public method Supported by the .NET Compact Framework ToSqlInt64 Converts this SqlDecimal structure to SqlInt64.
Public method Supported by the .NET Compact Framework ToSqlMoney Converts this SqlDecimal structure to SqlMoney.
Public method Supported by the .NET Compact Framework ToSqlSingle Converts this SqlDecimal structure to SqlSingle.
Public method Supported by the .NET Compact Framework ToSqlString Converts this SqlDecimal structure to SqlString.
Public method Supported by the .NET Compact Framework ToString Overridden. Converts this SqlDecimal structure to String.
Public method Static Supported by the .NET Compact Framework Truncate Truncates the specified SqlDecimal structure's value to the that you want position.
Top

  Name Description
Protected method Supported by the .NET Compact Framework Finalize  Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
Protected method Supported by the .NET Compact Framework MemberwiseClone  Creates a shallow copy of the current Object. (Inherited from Object.)
Top

  Name Description
Explicit interface implementation Method Supported by the .NET Compact Framework System.Xml.Serialization.IXmlSerializable.GetSchema This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Explicit interface implementation Method Supported by the .NET Compact Framework System.Xml.Serialization.IXmlSerializable.ReadXml This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Explicit interface implementation Method Supported by the .NET Compact Framework System.Xml.Serialization.IXmlSerializable.WriteXml This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Top

Community Additions

ADD
Show:
© 2015 Microsoft