SqlMoney Structure
.NET Framework 4.5
Represents a currency value ranging from -2 63 (or -922,337,203,685,477.5808) to 2 63 -1 (or +922,337,203,685,477.5807) with an accuracy to a ten-thousandth of currency unit to be stored in or retrieved from a database.
Namespace: System.Data.SqlTypes
Assembly: System.Data (in System.Data.dll)
The SqlMoney type exposes the following members.
| Name | Description | |
|---|---|---|
 | SqlMoney(Decimal) | Initializes a new instance of the SqlMoney class with the specified Decimal value. |
| SqlMoney(Double) | Initializes a new instance of the SqlMoney class with specified double value. |
| SqlMoney(Int32) | Initializes a new instance of the SqlMoney class with the specified integer value. |
| SqlMoney(Int64) | Initializes a new instance of the SqlMoney class with the specified long integer value. |
| Name | Description | |
|---|---|---|
| Add | Calculates the sum of the two SqlMoney parameters. |
| CompareTo(Object) | Compares this SqlMoney instance to the supplied Object and returns an indication of their relative values. |
| CompareTo(SqlMoney) | Compares this SqlMoney instance to the supplied SqlMoney and returns an indication of their relative values. |
| Divide | The division operator divides the first SqlMoney parameter by the second. |
| Equals(Object) | Compares the supplied object parameter to the Value property of the SqlMoney object. (Overrides ValueType.Equals(Object).) |
| Equals(SqlMoney, SqlMoney) | Performs a logical comparison of the two SqlMoney parameters to determine whether they are equal. |
| GetHashCode | Gets the hash code for this instance. (Overrides ValueType.GetHashCode().) |
| 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 the two SqlMoney parameters to determine whether the first is greater than the second. |
| GreaterThanOrEqual | Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than or equal to the second. |
| LessThan | Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than the second. |
| LessThanOrEqual | Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than or equal to the second. |
| Multiply | The multiplicaion operator calculates the product of the two SqlMoney parameters. |
| NotEquals | Performs a logical comparison of the two SqlMoney parameters to determine whether they are not equal. |
| Parse | Converts the String representation of a number to its SqlMoney equivalent. |
| Subtract | The subtraction operator subtracts the second SqlMoney parameter from the first. |
| ToDecimal | Converts the Value of this instance of SqlMoney as a Decimal structure. |
| ToDouble | Converts this SqlMoney structure to a Double. |
| ToInt32 | Converts this SqlMoney structure to an Int32. |
| ToInt64 | Converts the Value of this SqlMoney structure to an Int64. |
| ToSqlBoolean | Converts this SqlMoney structure to SqlBoolean. |
| ToSqlByte | Converts this SqlMoney structure to SqlByte. |
| ToSqlDecimal | Converts this SqlMoney structure to SqlDecimal. |
| ToSqlDouble | Converts this SqlMoney structure to SqlDouble. |
| ToSqlInt16 | Converts this SqlMoney structure to SqlInt16. |
| ToSqlInt32 | Converts this SqlMoney structure to SqlInt32. |
| ToSqlInt64 | Converts this SqlMoney structure to SqlInt64. |
| ToSqlSingle | Converts this SqlMoney structure to SqlSingle. |
| ToSqlString | Converts this SqlMoney structure to SqlString. |
| ToString | Converts this instance of SqlMoney to string. (Overrides ValueType.ToString().) |
| Name | Description | |
|---|---|---|
| Addition | Calculates the sum of the two SqlMoney parameters. |
| Division | The division operator divides the first SqlMoney parameter by the second. |
| Equality | Performs a logical comparison of the two SqlMoney parameters to determine whether they are equal. |
| Explicit(Double to SqlMoney) | This implicit operator converts the supplied SqlDouble parameter to SqlMoney. |
| Explicit(SqlBoolean to SqlMoney) | This implicit operator converts the supplied SqlBoolean parameter to SqlMoney. |
| Explicit(SqlDecimal to SqlMoney) | This operator converts the supplied SqlDecimal parameter to SqlMoney. |
| Explicit(SqlDouble to SqlMoney) | This operator converts the supplied SqlDouble parameter to SqlMoney. |
| Explicit(SqlMoney to Decimal) | Converts the specified SqlMoney structure to Decimal. |
| Explicit(SqlSingle to SqlMoney) | This operator converts the supplied SqlSingle parameter to SqlMoney. |
| Explicit(SqlString to SqlMoney) | This operator converts the SqlString parameter to SqlMoney. |
| GreaterThan | Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than the second. |
| GreaterThanOrEqual | Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than or equal to the second. |
| Implicit(Decimal to SqlMoney) | Converts the Decimal parameter to SqlMoney. |
| Implicit(Int64 to SqlMoney) | This implicit operator converts the supplied Int64 parameter to SqlMoney. |
| Implicit(SqlByte to SqlMoney) | This implicit operator converts the supplied SqlByte parameter to SqlMoney. |
| Implicit(SqlInt16 to SqlMoney) | This implicit operator converts the supplied SqlInt16 parameter to SqlMoney. |
| Implicit(SqlInt32 to SqlMoney) | This implicit operator converts the supplied SqlInt32 parameter to SqlMoney. |
| Implicit(SqlInt64 to SqlMoney) | This implicit operator converts the supplied SqlInt64 parameter to SqlMoney. |
| Inequality | Performs a logical comparison of the two SqlMoney parameters to determine whether they are not equal. |
| LessThan | Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than the second. |
| LessThanOrEqual | Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than or equal to the second. |
| Multiply | The multiplicaion operator calculates the product of the two SqlMoney parameters. |
| Subtraction | The subtraction operator subtracts the second SqlMoney parameter from the first. |
| UnaryNegation | The unary minus operator negates the SqlMoney parameter. |
| Name | Description | |
|---|---|---|
| MaxValue | Represents the maximum value that can be assigned to the Value property of an instance of the SqlMoney class. |
| MinValue | Represents the minimum value that can be assigned to Value property of an instance of the SqlMoney class. |
| Null | Represents a DBNull that can be assigned to this instance of the SqlMoney class. |
| Zero | Represents the zero value that can be assigned to the Value property of an instance of the SqlMoney class. |
| Name | Description | |
|---|---|---|
| IXmlSerializable.GetSchema | This member supports the .NET Framework infrastructure and is not intended to be used directly from your code. |
| IXmlSerializable.ReadXml | This member supports the .NET Framework infrastructure and is not intended to be used directly from your code. |
| IXmlSerializable.WriteXml | This member supports the .NET Framework infrastructure and is not intended to be used directly from your code. |
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
