SqlDecimal Members
.NET Framework 2.0
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 | |
---|---|---|
MaxPrecision | A constant representing the largest possible value for the Precision property. | |
MaxScale | A constant representing the maximum value for the Scale property. | |
MaxValue | A constant representing the maximum value of a SqlDecimal structure. | |
MinValue | A constant representing the minimum value for a SqlDecimal structure. | |
Null | Represents a null value that can be assigned to the Value property of an instance of the SqlMoney class. |
Name | Description | |
---|---|---|
BinData | Get the binary representation of the value of this SqlDecimal structure as an array of bytes. | |
Data | Gets the binary representation of this SqlDecimal structure as an array of integers. | |
IsNull | Indicates whether the Value of this SqlDecimal structure is null. | |
IsPositive | Indicates whether the Value of this SqlDecimal structure is greater than zero. | |
Precision | Gets the maximum number of digits used to represent the Value property. | |
Scale | Gets or sets the number of decimal places to which Value is resolved. | |
Value | Gets the value of the SqlDecimal structure. This property is read-only. |
(see also
Protected Methods
)
Top
Name | Description | |
---|---|---|
Abs | The Abs method gets the absolute value of the SqlDecimal parameter. | |
Add | Calculates the sum of the two SqlDecimal operators. | |
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. | |
Ceiling | Returns the smallest whole number greater than or equal to the specified SqlDecimal structure. | |
CompareTo | Overloaded. Compares this instance to the supplied object and returns an indication of their relative values. | |
ConvertToPrecScale | Adjusts the value of the SqlDecimal operand to the indicated precision and scale. | |
Divide | The division operator calculates the results of dividing the first SqlDecimal operand by the second. | |
Equals | Overloaded. Overridden. Returns a value that indicates whether an instance of SqlDecimal and the supplied object parameter represent the same value. | |
Floor | Rounds a specified SqlDecimal number to the next lower whole number. | |
GetHashCode | Overridden. Returns the hash code for this instance. | |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
GetXsdType | Returns the XML Schema definition language (XSD) of the specified XmlSchemaSet. | |
GreaterThan | Performs a logical comparison of two SqlDecimal structures to determine whether the first is greater than the second. | |
GreaterThanOrEqual | Performs a logical comparison of the two SqlDecimal parameters to determine whether the first is greater than or equal to the second. | |
LessThan | Performs a logical comparison of two SqlDecimal structures to determine whether the first is less than the second. | |
LessThanOrEqual | Performs a logical comparison of the two SqlDecimal parameters to determine whether the first is less than or equal to the second. | |
Multiply | The multiplication operator computes the product of the two SqlDecimal parameters. | |
NotEquals | Performs a logical comparison of the two SqlDecimal parameters to determine whether they are not equal. | |
op_Addition | Calculates the sum of the two SqlDecimal operators. | |
op_Division | The division operator calculates the results of dividing the first SqlDecimal operand by the second. | |
op_Equality | Performs a logical comparison of the two SqlDecimal operands to determine whether they are equal. | |
op_Explicit | Overloaded. Converts the supplied structure to SqlDecimal. | |
op_GreaterThan | Performs a logical comparison of two SqlDecimal structures to determine whether the first is greater than the second. | |
op_GreaterThanOrEqual | Performs a logical comparison of the two SqlDecimal parameters to determine whether the first is greater than or equal to the second. | |
op_Implicit | Overloaded. Converts the supplied structure to SqlDecimal. | |
op_Inequality | Performs a logical comparison of the two SqlDecimal parameters to determine whether they are not equal. | |
op_LessThan | Performs a logical comparison of two SqlDecimal structures to determine whether the first is less than the second. | |
op_LessThanOrEqual | Performs a logical comparison of the two SqlDecimal parameters to determine whether the first is less than or equal to the second. | |
op_Multiply | The multiplication operator computes the product of the two SqlDecimal parameters. | |
op_Subtraction | Calculates the results of subtracting the second SqlDecimal operand from the first. | |
op_UnaryNegation | The unary minus operator negates the SqlDecimal parameter. | |
Parse | Converts the String representation of a number to its SqlDecimal equivalent. | |
Power | Raises the value of the specified SqlDecimal structure to the specified exponential power. | |
ReferenceEquals | Determines whether the specified Object instances are the same instance. (Inherited from Object.) | |
Round | Gets the number nearest the specified SqlDecimal structure's value with the specified precision. | |
Sign | Gets a value that indicates the sign of a SqlDecimal structure's Value property. | |
Subtract | Calculates the results of subtracting the second SqlDecimal operand from the first. | |
ToDouble | Returns the a double equal to the contents of the Value property of this instance. | |
ToSqlBoolean | Converts this SqlDecimal structure to SqlBoolean. | |
ToSqlByte | Converts this SqlDecimal structure to SqlByte. | |
ToSqlDouble | Converts this SqlDecimal structure to SqlDouble. | |
ToSqlInt16 | Converts this SqlDecimal structure to SqlInt16. | |
ToSqlInt32 | Converts this SqlDecimal structure to SqlInt32. | |
ToSqlInt64 | Converts this SqlDecimal structure to SqlInt64. | |
ToSqlMoney | Converts this SqlDecimal structure to SqlMoney. | |
ToSqlSingle | Converts this SqlDecimal structure to SqlSingle. | |
ToSqlString | Converts this SqlDecimal structure to SqlString. | |
ToString | Overridden. Converts this SqlDecimal structure to String. | |
Truncate | Truncates the specified SqlDecimal structure's value to the that you want position. |
Name | Description | |
---|---|---|
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.) | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
Name | Description | |
---|---|---|
System.Xml.Serialization.IXmlSerializable.GetSchema | This member supports the .NET Framework infrastructure and is not intended to be used directly from your code. | |
System.Xml.Serialization.IXmlSerializable.ReadXml | This member supports the .NET Framework infrastructure and is not intended to be used directly from your code. | |
System.Xml.Serialization.IXmlSerializable.WriteXml | This member supports the .NET Framework infrastructure and is not intended to be used directly from your code. |
Community Additions
ADD
Show: