SqlMoney

SqlMoney

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

A structure that represents a currency value ranging from -2 63 (-922,337,203,685,477.5808) to 2 63-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( )



ADO. NET in a Nutshell
ADO.NET in a Nutshell
ISBN: 0596003617
EAN: 2147483647
Year: 2005
Pages: 415

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net