Export (0) Print
Expand All

SqlMoney Structure

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)

[SerializableAttribute]
public struct SqlMoney : INullable, IComparable, 
	IXmlSerializable

The SqlMoney type exposes the following members.

  NameDescription
Public methodSupported by the XNA FrameworkSqlMoney(Decimal)Initializes a new instance of the SqlMoney class with the specified Decimal value.
Public methodSupported by the XNA FrameworkSqlMoney(Double)Initializes a new instance of the SqlMoney class with specified double value.
Public methodSupported by the XNA FrameworkSqlMoney(Int32)Initializes a new instance of the SqlMoney class with the specified integer value.
Public methodSupported by the XNA FrameworkSqlMoney(Int64)Initializes a new instance of the SqlMoney class with the specified long integer value.
Top

  NameDescription
Public propertySupported by the XNA FrameworkIsNullReturns a Boolean value that indicates whether this SqlMoney structure is null.
Public propertySupported by the XNA FrameworkValueGets the monetary value of an instance of the SqlMoney structure. This property is read-only.
Top

  NameDescription
Public methodStatic memberSupported by the XNA FrameworkAddCalculates the sum of the two SqlMoney parameters.
Public methodSupported by the XNA FrameworkCompareTo(Object)Compares this SqlMoney instance to the supplied Object and returns an indication of their relative values.
Public methodSupported by the XNA FrameworkCompareTo(SqlMoney)Compares this SqlMoney instance to the supplied SqlMoney and returns an indication of their relative values.
Public methodStatic memberSupported by the XNA FrameworkDivideThe division operator divides the first SqlMoney parameter by the second.
Public methodSupported by the XNA FrameworkEquals(Object)Compares the supplied object parameter to the Value property of the SqlMoney object. (Overrides ValueType.Equals(Object).)
Public methodStatic memberSupported by the XNA FrameworkEquals(SqlMoney, SqlMoney)Performs a logical comparison of the two SqlMoney parameters to determine whether they are equal.
Public methodSupported by the XNA FrameworkGetHashCodeGets the hash code for this instance. (Overrides ValueType.GetHashCode().)
Public methodSupported by the XNA FrameworkGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodStatic memberSupported by the XNA FrameworkGetXsdTypeReturns the XML Schema definition language (XSD) of the specified XmlSchemaSet.
Public methodStatic memberSupported by the XNA FrameworkGreaterThanPerforms a logical comparison of the two SqlMoney parameters to determine whether the first is greater than the second.
Public methodStatic memberSupported by the XNA FrameworkGreaterThanOrEqualPerforms a logical comparison of the two SqlMoney parameters to determine whether the first is greater than or equal to the second.
Public methodStatic memberSupported by the XNA FrameworkLessThanPerforms a logical comparison of the two SqlMoney parameters to determine whether the first is less than the second.
Public methodStatic memberSupported by the XNA FrameworkLessThanOrEqualPerforms a logical comparison of the two SqlMoney parameters to determine whether the first is less than or equal to the second.
Public methodStatic memberSupported by the XNA FrameworkMultiplyThe multiplicaion operator calculates the product of the two SqlMoney parameters.
Public methodStatic memberSupported by the XNA FrameworkNotEqualsPerforms a logical comparison of the two SqlMoney parameters to determine whether they are not equal.
Public methodStatic memberSupported by the XNA FrameworkParseConverts the String representation of a number to its SqlMoney equivalent.
Public methodStatic memberSupported by the XNA FrameworkSubtractThe subtraction operator subtracts the second SqlMoney parameter from the first.
Public methodSupported by the XNA FrameworkToDecimalConverts the Value of this instance of SqlMoney as a Decimal structure.
Public methodSupported by the XNA FrameworkToDoubleConverts this SqlMoney structure to a Double.
Public methodSupported by the XNA FrameworkToInt32Converts this SqlMoney structure to an Int32.
Public methodSupported by the XNA FrameworkToInt64Converts the Value of this SqlMoney structure to an Int64.
Public methodSupported by the XNA FrameworkToSqlBooleanConverts this SqlMoney structure to SqlBoolean.
Public methodSupported by the XNA FrameworkToSqlByteConverts this SqlMoney structure to SqlByte.
Public methodSupported by the XNA FrameworkToSqlDecimalConverts this SqlMoney structure to SqlDecimal.
Public methodSupported by the XNA FrameworkToSqlDoubleConverts this SqlMoney structure to SqlDouble.
Public methodSupported by the XNA FrameworkToSqlInt16Converts this SqlMoney structure to SqlInt16.
Public methodSupported by the XNA FrameworkToSqlInt32Converts this SqlMoney structure to SqlInt32.
Public methodSupported by the XNA FrameworkToSqlInt64Converts this SqlMoney structure to SqlInt64.
Public methodSupported by the XNA FrameworkToSqlSingleConverts this SqlMoney structure to SqlSingle.
Public methodSupported by the XNA FrameworkToSqlStringConverts this SqlMoney structure to SqlString.
Public methodSupported by the XNA FrameworkToStringConverts this instance of SqlMoney to string. (Overrides ValueType.ToString().)
Top

  NameDescription
Public operatorStatic memberSupported by the XNA FrameworkAdditionCalculates the sum of the two SqlMoney parameters.
Public operatorStatic memberSupported by the XNA FrameworkDivisionThe division operator divides the first SqlMoney parameter by the second.
Public operatorStatic memberSupported by the XNA FrameworkEqualityPerforms a logical comparison of the two SqlMoney parameters to determine whether they are equal.
Public operatorStatic memberSupported by the XNA FrameworkExplicit(Double to SqlMoney)This implicit operator converts the supplied SqlDouble parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkExplicit(SqlBoolean to SqlMoney)This implicit operator converts the supplied SqlBoolean parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkExplicit(SqlDecimal to SqlMoney)This operator converts the supplied SqlDecimal parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkExplicit(SqlDouble to SqlMoney)This operator converts the supplied SqlDouble parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkExplicit(SqlMoney to Decimal)Converts the specified SqlMoney structure to Decimal.
Public operatorStatic memberSupported by the XNA FrameworkExplicit(SqlSingle to SqlMoney)This operator converts the supplied SqlSingle parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkExplicit(SqlString to SqlMoney)This operator converts the SqlString parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkGreaterThanPerforms a logical comparison of the two SqlMoney parameters to determine whether the first is greater than the second.
Public operatorStatic memberSupported by the XNA FrameworkGreaterThanOrEqualPerforms a logical comparison of the two SqlMoney parameters to determine whether the first is greater than or equal to the second.
Public operatorStatic memberSupported by the XNA FrameworkImplicit(Decimal to SqlMoney)Converts the Decimal parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkImplicit(Int64 to SqlMoney)This implicit operator converts the supplied Int64 parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkImplicit(SqlByte to SqlMoney)This implicit operator converts the supplied SqlByte parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkImplicit(SqlInt16 to SqlMoney)This implicit operator converts the supplied SqlInt16 parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkImplicit(SqlInt32 to SqlMoney)This implicit operator converts the supplied SqlInt32 parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkImplicit(SqlInt64 to SqlMoney)This implicit operator converts the supplied SqlInt64 parameter to SqlMoney.
Public operatorStatic memberSupported by the XNA FrameworkInequalityPerforms a logical comparison of the two SqlMoney parameters to determine whether they are not equal.
Public operatorStatic memberSupported by the XNA FrameworkLessThanPerforms a logical comparison of the two SqlMoney parameters to determine whether the first is less than the second.
Public operatorStatic memberSupported by the XNA FrameworkLessThanOrEqualPerforms a logical comparison of the two SqlMoney parameters to determine whether the first is less than or equal to the second.
Public operatorStatic memberSupported by the XNA FrameworkMultiplyThe multiplicaion operator calculates the product of the two SqlMoney parameters.
Public operatorStatic memberSupported by the XNA FrameworkSubtractionThe subtraction operator subtracts the second SqlMoney parameter from the first.
Public operatorStatic memberSupported by the XNA FrameworkUnaryNegationThe unary minus operator negates the SqlMoney parameter.
Top

  NameDescription
Public fieldStatic memberSupported by the XNA FrameworkMaxValueRepresents the maximum value that can be assigned to the Value property of an instance of the SqlMoney class.
Public fieldStatic memberSupported by the XNA FrameworkMinValueRepresents the minimum value that can be assigned to Value property of an instance of the SqlMoney class.
Public fieldStatic memberSupported by the XNA FrameworkNullRepresents a DBNull that can be assigned to this instance of the SqlMoney class.
Public fieldStatic memberSupported by the XNA FrameworkZeroRepresents the zero value that can be assigned to the Value property of an instance of the SqlMoney class.
Top

  NameDescription
Explicit interface implemetationPrivate methodSupported by the XNA FrameworkIXmlSerializable.GetSchemaThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Explicit interface implemetationPrivate methodSupported by the XNA FrameworkIXmlSerializable.ReadXmlThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Explicit interface implemetationPrivate methodSupported by the XNA FrameworkIXmlSerializable.WriteXmlThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Top

The actual value of the SqlMoney object is stored in Value.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, 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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2014 Microsoft