SqlMoney Structure
TOC
Collapse the table of content
Expand the table of content

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

NameDescription
System_CAPS_pubmethodSqlMoney(Decimal)

Initializes a new instance of the SqlMoney class with the specified Decimal value.

System_CAPS_pubmethodSqlMoney(Double)

Initializes a new instance of the SqlMoney class with specified double value.

System_CAPS_pubmethodSqlMoney(Int32)

Initializes a new instance of the SqlMoney class with the specified integer value.

System_CAPS_pubmethodSqlMoney(Int64)

Initializes a new instance of the SqlMoney class with the specified long integer value.

NameDescription
System_CAPS_pubpropertyIsNull

Returns a Boolean value that indicates whether this SqlMoney structure is null.

System_CAPS_pubpropertyValue

Gets the monetary value of an instance of the SqlMoney structure. This property is read-only.

NameDescription
System_CAPS_pubmethodSystem_CAPS_staticAdd(SqlMoney, SqlMoney)

Calculates the sum of the two SqlMoney parameters.

System_CAPS_pubmethodCompareTo(Object)

Compares this SqlMoney instance to the supplied Object and returns an indication of their relative values.

System_CAPS_pubmethodCompareTo(SqlMoney)

Compares this SqlMoney instance to the supplied SqlMoney and returns an indication of their relative values.

System_CAPS_pubmethodSystem_CAPS_staticDivide(SqlMoney, SqlMoney)

The division operator divides the first SqlMoney parameter by the second.

System_CAPS_pubmethodEquals(Object)

Compares the supplied object parameter to the Value property of the SqlMoney object.(Overrides ValueType.Equals(Object).)

System_CAPS_pubmethodSystem_CAPS_staticEquals(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether they are equal.

System_CAPS_pubmethodGetHashCode()

Gets the hash code for this instance.(Overrides ValueType.GetHashCode().)

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_pubmethodSystem_CAPS_staticGetXsdType(XmlSchemaSet)

Returns the XML Schema definition language (XSD) of the specified XmlSchemaSet.

System_CAPS_pubmethodSystem_CAPS_staticGreaterThan(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than the second.

System_CAPS_pubmethodSystem_CAPS_staticGreaterThanOrEqual(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than or equal to the second.

System_CAPS_pubmethodSystem_CAPS_staticLessThan(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than the second.

System_CAPS_pubmethodSystem_CAPS_staticLessThanOrEqual(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than or equal to the second.

System_CAPS_pubmethodSystem_CAPS_staticMultiply(SqlMoney, SqlMoney)

The multiplicaion operator calculates the product of the two SqlMoney parameters.

System_CAPS_pubmethodSystem_CAPS_staticNotEquals(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether they are not equal.

System_CAPS_pubmethodSystem_CAPS_staticParse(String)

Converts the String representation of a number to its SqlMoney equivalent.

System_CAPS_pubmethodSystem_CAPS_staticSubtract(SqlMoney, SqlMoney)

The subtraction operator subtracts the second SqlMoney parameter from the first.

System_CAPS_pubmethodToDecimal()

Converts the Value of this instance of SqlMoney as a Decimal structure.

System_CAPS_pubmethodToDouble()

Converts this SqlMoney structure to a Double.

System_CAPS_pubmethodToInt32()

Converts this SqlMoney structure to an Int32.

System_CAPS_pubmethodToInt64()

Converts the Value of this SqlMoney structure to an Int64.

System_CAPS_pubmethodToSqlBoolean()

Converts this SqlMoney structure to SqlBoolean.

System_CAPS_pubmethodToSqlByte()

Converts this SqlMoney structure to SqlByte.

System_CAPS_pubmethodToSqlDecimal()

Converts this SqlMoney structure to SqlDecimal.

System_CAPS_pubmethodToSqlDouble()

Converts this SqlMoney structure to SqlDouble.

System_CAPS_pubmethodToSqlInt16()

Converts this SqlMoney structure to SqlInt16.

System_CAPS_pubmethodToSqlInt32()

Converts this SqlMoney structure to SqlInt32.

System_CAPS_pubmethodToSqlInt64()

Converts this SqlMoney structure to SqlInt64.

System_CAPS_pubmethodToSqlSingle()

Converts this SqlMoney structure to SqlSingle.

System_CAPS_pubmethodToSqlString()

Converts this SqlMoney structure to SqlString.

System_CAPS_pubmethodToString()

Converts this instance of SqlMoney to string.(Overrides ValueType.ToString().)

NameDescription
System_CAPS_pubfieldSystem_CAPS_staticMaxValue

Represents the maximum value that can be assigned to the Value property of an instance of the SqlMoney class.

System_CAPS_pubfieldSystem_CAPS_staticMinValue

Represents the minimum value that can be assigned to Value property of an instance of the SqlMoney class.

System_CAPS_pubfieldSystem_CAPS_staticNull

Represents a DBNull that can be assigned to this instance of the SqlMoney class.

System_CAPS_pubfieldSystem_CAPS_staticZero

Represents the zero value that can be assigned to the Value property of an instance of the SqlMoney class.

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticAddition(SqlMoney, SqlMoney)

Calculates the sum of the two SqlMoney parameters.

System_CAPS_puboperatorSystem_CAPS_staticDivision(SqlMoney, SqlMoney)

The division operator divides the first SqlMoney parameter by the second.

System_CAPS_puboperatorSystem_CAPS_staticEquality(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether they are equal.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(Double to SqlMoney)

This implicit operator converts the supplied SqlDouble parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlBoolean to SqlMoney)

This implicit operator converts the supplied SqlBoolean parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlDecimal to SqlMoney)

This operator converts the supplied SqlDecimal parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlDouble to SqlMoney)

This operator converts the supplied SqlDouble parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlMoney to Decimal)

Converts the specified SqlMoney structure to Decimal.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlSingle to SqlMoney)

This operator converts the supplied SqlSingle parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlString to SqlMoney)

This operator converts the SqlString parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticGreaterThan(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than the second.

System_CAPS_puboperatorSystem_CAPS_staticGreaterThanOrEqual(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether the first is greater than or equal to the second.

System_CAPS_puboperatorSystem_CAPS_staticImplicit(Decimal to SqlMoney)

Converts the Decimal parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticImplicit(Int64 to SqlMoney)

This implicit operator converts the supplied Int64 parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticImplicit(SqlByte to SqlMoney)

This implicit operator converts the supplied SqlByte parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticImplicit(SqlInt16 to SqlMoney)

This implicit operator converts the supplied SqlInt16 parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticImplicit(SqlInt32 to SqlMoney)

This implicit operator converts the supplied SqlInt32 parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticImplicit(SqlInt64 to SqlMoney)

This implicit operator converts the supplied SqlInt64 parameter to SqlMoney.

System_CAPS_puboperatorSystem_CAPS_staticInequality(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether they are not equal.

System_CAPS_puboperatorSystem_CAPS_staticLessThan(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than the second.

System_CAPS_puboperatorSystem_CAPS_staticLessThanOrEqual(SqlMoney, SqlMoney)

Performs a logical comparison of the two SqlMoney parameters to determine whether the first is less than or equal to the second.

System_CAPS_puboperatorSystem_CAPS_staticMultiply(SqlMoney, SqlMoney)

The multiplicaion operator calculates the product of the two SqlMoney parameters.

System_CAPS_puboperatorSystem_CAPS_staticSubtraction(SqlMoney, SqlMoney)

The subtraction operator subtracts the second SqlMoney parameter from the first.

System_CAPS_puboperatorSystem_CAPS_staticUnaryNegation(SqlMoney)

The unary minus operator negates the SqlMoney parameter.

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.GetSchema()

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.ReadXml(XmlReader)

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.WriteXml(XmlWriter)

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

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

.NET Framework
Available since 1.1

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

Return to top
Show:
© 2016 Microsoft