''SqlMoney'' '''

SqlMoney

System.Data.SqlTypes (system.data.dll) struct

A structure that represents a currency value ranging from -263 (-922,337,203,685,477.5808) to 263-1 (922,337,203,685,477.5807) with an accuracy to a ten-thousandth of a unit. It maps to the SQL Server money data type.

public struct SqlMoney : INullable, IComparable {
// Public Constructors
   public SqlMoney( decimal value);  
   public SqlMoney( double value);  
   public SqlMoney( int value);  
   public SqlMoney( long value);  
// Public Static Fields
   public static readonly SqlMoney MaxValue;          // =922337203685477.5807
   public static readonly SqlMoney MinValue;          // =-922337203685477.5808
   public static readonly SqlMoney Null;              // =Null
   public static readonly SqlMoney Zero;              // =0
// Public Instance Properties
   public bool IsNull{get; }                          // implements INullable
   public decimal Value{get; } 
// Public Static Methods
   public static SqlMoney Add( SqlMoney x, SqlMoney y);  
   public static SqlMoney Divide( SqlMoney x, SqlMoney y);  
   public static SqlBoolean Equals( SqlMoney x, SqlMoney y);  
   public static SqlBoolean GreaterThan(SqlMoney x, SqlMoney y);
   public static SqlBoolean GreaterThanOrEqual(SqlMoney x, SqlMoney y);
   public static SqlBoolean LessThan(SqlMoney x, SqlMoney y);  
   public static SqlBoolean LessThanOrEqual(SqlMoney x, SqlMoney y);
   public static SqlMoney Multiply( SqlMoney x, SqlMoney y);  
   public static SqlBoolean NotEquals(SqlMoney x, SqlMoney y);
   public static SqlMoney Parse( string s);  
   public static SqlMoney Subtract( SqlMoney x, SqlMoney y);  
   public static SqlMoney operator *(SqlMoney x, SqlMoney y);
   public static SqlMoney operator /(SqlMoney x, SqlMoney y);
   public static SqlMoney operator -( SqlMoney x);  
   public static SqlMoney operator -(SqlMoney x, SqlMoney y);
   public static SqlMoney operator +(SqlMoney x, SqlMoney y);
   public static SqlBoolean operator !=(SqlMoney x, SqlMoney y);
   public static SqlBoolean operator <(SqlMoney x, SqlMoney y);
   public static SqlBoolean operator <=(SqlMoney x, SqlMoney y);
   public static SqlBoolean operator ==(SqlMoney x, SqlMoney y);
   public static SqlBoolean operator >(SqlMoney x,  SqlMoney y);
   public static SqlBoolean operator >=(SqlMoney x, SqlMoney y);
   public static explicit operator decimal( SqlMoney x);  
   public static explicit operator SqlMoney( SqlBoolean x);  
   public static explicit operator SqlMoney( SqlDecimal x);  
   public static explicit operator SqlMoney( SqlDouble x);  
   public static explicit operator SqlMoney( SqlSingle x);  
   public static explicit operator SqlMoney( SqlString x);  
   public static implicit operator SqlMoney( decimal x);  
   public static implicit operator SqlMoney( SqlByte x);  
   public static implicit operator SqlMoney( SqlInt16 x);  
   public static implicit operator SqlMoney( SqlInt32 x);  
   public static implicit operator SqlMoney( SqlInt64 x);  
// Public Instance Methods
   public int CompareTo( object value);              // implements IComparable
   public override bool Equals( object value);       // overrides ValueType
   public override int GetHashCode(  );               // overrides ValueType
   public decimal ToDecimal(  );  
   public double ToDouble(  );  
   public int ToInt32(  );  
   public long ToInt64(  );  
   public SqlBoolean ToSqlBoolean(  );  
   public SqlByte ToSqlByte(  );  
   public SqlDecimal ToSqlDecimal(  );  
   public SqlDouble ToSqlDouble(  );  
   public SqlInt16 ToSqlInt16(  );  
   public SqlInt32 ToSqlInt32(  );  
   public SqlInt64 ToSqlInt64(  );  
   public SqlSingle ToSqlSingle(  );  
   public SqlString ToSqlString(  );  
   public override string ToString(  );               // overrides ValueType
}

Hierarchy

System.Object figs/U2192.gif System.ValueType figs/U2192.gif SqlMoney(INullable, System.IComparable)

Returned By

System.Data.SqlClient.SqlDataReader.GetSqlMoney( ) , SqlBoolean.ToSqlMoney( ) , SqlByte.ToSqlMoney( ) , SqlDecimal.ToSqlMoney( ) , SqlDouble.ToSqlMoney( ) , SqlInt16.ToSqlMoney( ) , SqlInt32.ToSqlMoney( ) , SqlInt64.ToSqlMoney( ) , SqlSingle.ToSqlMoney( ) , SqlString.ToSqlMoney( )



    Part I: ADO.NET Tutorial
    Part II: ADO.NET Core Classes
    Part III: API Quick Reference
    Chapter 34. The System.Data Namespace