Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

SqlMoney Structure

.NET Framework 4

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)
C#
C++
F#
VB
Copy 
[SerializableAttribute]
public struct SqlMoney : INullable, IComparable, 
	IXmlSerializable

The SqlMoney type exposes the following members.

  Name Description
Public method Supported by the XNA Framework SqlMoney(Decimal) Initializes a new instance of the SqlMoney class with the specified Decimal value.
Public method Supported by the XNA Framework SqlMoney(Double) Initializes a new instance of the SqlMoney class with specified double value.
Public method Supported by the XNA Framework SqlMoney(Int32) Initializes a new instance of the SqlMoney class with the specified integer value.
Public method Supported by the XNA Framework SqlMoney(Int64) Initializes a new instance of the SqlMoney class with the specified long integer value.
Top
  Name Description
Public property Supported by the XNA Framework IsNull Returns a Boolean value that indicates whether this SqlMoney structure is null.
Public property Supported by the XNA Framework Value Gets the monetary value of an instance of the SqlMoney structure. This property is read-only.
Top
  Name Description
Public method Static member Supported by the XNA Framework Add Calculates the sum of the two SqlMoney parameters.
Public method Supported by the XNA Framework CompareTo(Object) Compares this SqlMoney instance to the supplied Object and returns an indication of their relative values.
Public method Supported by the XNA Framework CompareTo(SqlMoney) Compares this SqlMoney instance to the supplied SqlMoney and returns an indication of their relative values.
Public method Static member Supported by the XNA Framework Divide The division operator divides the first SqlMoney parameter by the second.
Public method Supported by the XNA Framework Equals(Object) Compares the supplied object parameter to the Value property of the SqlMoney object. (Overrides ValueType.Equals(Object).)
Public method Static member Supported by the XNA Framework Equals(SqlMoney, SqlMoney) Performs a logical comparison of the two SqlMoney parameters to determine whether they are equal.
Protected method Supported by the XNA Framework Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method Supported by the XNA Framework GetHashCode Gets the hash code for this instance. (Overrides ValueType.GetHashCode().)
Public method Supported by the XNA Framework GetType Gets the Type of the current instance. (Inherited from Object.)
Public method Static member Supported by the XNA Framework GetXsdType Returns the XML Schema definition language (XSD) of the specified XmlSchemaSet.
Public method Static member Supported by the XNA Framework GreaterThan Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than the second.
Public method Static member Supported by the XNA Framework GreaterThanOrEqual Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than or equal to the second.
Public method Static member Supported by the XNA Framework LessThan Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than the second.
Public method Static member Supported by the XNA Framework LessThanOrEqual Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than or equal to the second.
Protected method Supported by the XNA Framework MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method Static member Supported by the XNA Framework Multiply The multiplicaion operator calculates the product of the two SqlMoney parameters.
Public method Static member Supported by the XNA Framework NotEquals Performs a logical comparison of the two SqlMoney parameters to determine whether they are not equal.
Public method Static member Supported by the XNA Framework Parse Converts the String representation of a number to its SqlMoney equivalent.
Public method Static member Supported by the XNA Framework Subtract The subtraction operator subtracts the second SqlMoney parameter from the first.
Public method Supported by the XNA Framework ToDecimal Converts the Value of this instance of SqlMoney as a Decimal structure.
Public method Supported by the XNA Framework ToDouble Converts this SqlMoney structure to a Double.
Public method Supported by the XNA Framework ToInt32 Converts this SqlMoney structure to an Int32.
Public method Supported by the XNA Framework ToInt64 Converts the Value of this SqlMoney structure to an Int64.
Public method Supported by the XNA Framework ToSqlBoolean Converts this SqlMoney structure to SqlBoolean.
Public method Supported by the XNA Framework ToSqlByte Converts this SqlMoney structure to SqlByte.
Public method Supported by the XNA Framework ToSqlDecimal Converts this SqlMoney structure to SqlDecimal.
Public method Supported by the XNA Framework ToSqlDouble Converts this SqlMoney structure to SqlDouble.
Public method Supported by the XNA Framework ToSqlInt16 Converts this SqlMoney structure to SqlInt16.
Public method Supported by the XNA Framework ToSqlInt32 Converts this SqlMoney structure to SqlInt32.
Public method Supported by the XNA Framework ToSqlInt64 Converts this SqlMoney structure to SqlInt64.
Public method Supported by the XNA Framework ToSqlSingle Converts this SqlMoney structure to SqlSingle.
Public method Supported by the XNA Framework ToSqlString Converts this SqlMoney structure to SqlString.
Public method Supported by the XNA Framework ToString Converts this instance of SqlMoney to string. (Overrides ValueType.ToString().)
Top
  Name Description
Public operator Static member Supported by the XNA Framework Addition Calculates the sum of the two SqlMoney parameters.
Public operator Static member Supported by the XNA Framework Division The division operator divides the first SqlMoney parameter by the second.
Public operator Static member Supported by the XNA Framework Equality Performs a logical comparison of the two SqlMoney parameters to determine whether they are equal.
Public operator Static member Supported by the XNA Framework Explicit(Double to SqlMoney) This implicit operator converts the supplied SqlDouble parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Explicit(SqlBoolean to SqlMoney) This implicit operator converts the supplied SqlBoolean parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Explicit(SqlDecimal to SqlMoney) This operator converts the supplied SqlDecimal parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Explicit(SqlDouble to SqlMoney) This operator converts the supplied SqlDouble parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Explicit(SqlMoney to Decimal) Converts the specified SqlMoney structure to Decimal.
Public operator Static member Supported by the XNA Framework Explicit(SqlSingle to SqlMoney) This operator converts the supplied SqlSingle parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Explicit(SqlString to SqlMoney) This operator converts the SqlString parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework GreaterThan Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than the second.
Public operator Static member Supported by the XNA Framework GreaterThanOrEqual Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than or equal to the second.
Public operator Static member Supported by the XNA Framework Implicit(Decimal to SqlMoney) Converts the Decimal parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Implicit(Int64 to SqlMoney) This implicit operator converts the supplied Int64 parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Implicit(SqlByte to SqlMoney) This implicit operator converts the supplied SqlByte parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Implicit(SqlInt16 to SqlMoney) This implicit operator converts the supplied SqlInt16 parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Implicit(SqlInt32 to SqlMoney) This implicit operator converts the supplied SqlInt32 parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Implicit(SqlInt64 to SqlMoney) This implicit operator converts the supplied SqlInt64 parameter to SqlMoney.
Public operator Static member Supported by the XNA Framework Inequality Performs a logical comparison of the two SqlMoney parameters to determine whether they are not equal.
Public operator Static member Supported by the XNA Framework LessThan Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than the second.
Public operator Static member Supported by the XNA Framework LessThanOrEqual Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than or equal to the second.
Public operator Static member Supported by the XNA Framework Multiply The multiplicaion operator calculates the product of the two SqlMoney parameters.
Public operator Static member Supported by the XNA Framework Subtraction The subtraction operator subtracts the second SqlMoney parameter from the first.
Public operator Static member Supported by the XNA Framework UnaryNegation The unary minus operator negates the SqlMoney parameter.
Top
  Name Description
Public field Static member Supported by the XNA Framework MaxValue Represents the maximum value that can be assigned to the Value property of an instance of the SqlMoney class.
Public field Static member Supported by the XNA Framework MinValue Represents the minimum value that can be assigned to Value property of an instance of the SqlMoney class.
Public field Static member Supported by the XNA Framework Null Represents a DBNull that can be assigned to this instance of the SqlMoney class.
Public field Static member Supported by the XNA Framework Zero Represents the zero value that can be assigned to the Value property of an instance of the SqlMoney class.
Top
  Name Description
Explicit interface implemetation Private method Supported by the XNA Framework IXmlSerializable.GetSchema This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Explicit interface implemetation Private method Supported by the XNA Framework IXmlSerializable.ReadXml This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Explicit interface implemetation Private method Supported by the XNA Framework IXmlSerializable.WriteXml This 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, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

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.
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Currency Symbol Support?
Is there any currency symbol support as it is supported in SQL SERVER 2008 R2 and is stated here:
http://msdn.microsoft.com/en-us/library/ms188688.aspx

History