SqlInt32

SqlInt32

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

A structure that represents a 32-bit signed integer that can contain a value ranging from -2 31 (-2,147,483,648) to 2 31-1 (2,147,483,647). It maps to the SQL Server int data type.

 public struct  SqlInt32  : INullable, IComparable {  // Public Constructors  public  SqlInt32  ( int   value   );  // Public Static Fields  public static readonly SqlInt32  MaxValue  ;  // =2147483647  public static readonly SqlInt32  MinValue  ;  // =-2147483648  public static readonly SqlInt32  Null  ;  // =Null  public static readonly SqlInt32  Zero  ;  // =0   // Public Instance Properties  public bool  IsNull  {get; }  // implements INullable  public int  Value  {get; }  // Public Static Methods  public static SqlInt32  Add  ( SqlInt32   x   , SqlInt32   y   );  
   public static SqlInt32  BitwiseAnd  (SqlInt32   x   , SqlInt32   y   );  
   public static SqlInt32  BitwiseOr  ( SqlInt32   x   , SqlInt32   y   );  
   public static SqlInt32  Divide  ( SqlInt32   x   , SqlInt32   y   );  
   public static SqlBoolean  Equals  ( SqlInt32   x   , SqlInt32   y   );  
   public static SqlBoolean  GreaterThan  (SqlInt32   x   , SqlInt32   y   );
   public static SqlBoolean  GreaterThanOrEqual  (SqlInt32   x   , SqlInt32   y   );
   public static SqlBoolean  LessThan  (SqlInt32   x   , SqlInt32   y   );  
   public static SqlBoolean  LessThanOrEqual  (SqlInt32   x   , SqlInt32   y   );
   public static SqlInt32  Mod  ( SqlInt32   x   , SqlInt32   y   );  
   public static SqlInt32  Multiply  ( SqlInt32   x   , SqlInt32   y   );  
   public static SqlBoolean  NotEquals  (SqlInt32   x   , SqlInt32   y   );
   public static SqlInt32  OnesComplement  ( SqlInt32   x   );  
   public static SqlInt32 operator  &  (SqlInt32   x   , SqlInt32   y   );
   public static SqlInt32 operator   (SqlInt32   x   , SqlInt32   y   );
   public static SqlInt32 operator  ^  (SqlInt32   x   , SqlInt32   y   );
   public static SqlInt32 operator  ~  (SqlInt32   x   );
   public static SqlInt32  Parse  ( string   s   );  
   public static SqlInt32  Subtract  ( SqlInt32   x   , SqlInt32   y   );  
   public static SqlInt32  Xor  ( SqlInt32   x   , SqlInt32   y   );  
   public static SqlInt32 operator  %  (SqlInt32   x   , SqlInt32   y   );
   public static SqlInt32 operator  *  (SqlInt32   x   , SqlInt32   y   );
   public static SqlInt32 operator  /  (SqlInt32   x   ,  SqlInt32   y   );
   public static SqlInt32 operator  -  ( SqlInt32   x   );  
   public static SqlInt32 operator  -  (SqlInt32   x   , SqlInt32   y   );
   public static SqlInt32 operator  +  (SqlInt32   x   , SqlInt32   y   );
   public static SqlBoolean operator  !=  (SqlInt32   x   , SqlInt32   y   );
   public static SqlBoolean operator  <  (SqlInt32   x   , SqlInt32   y   );
   public static SqlBoolean operator  <=  (SqlInt32   x   , SqlInt32   y   );
   public static SqlBoolean operator  ==  (SqlInt32   x   , SqlInt32   y   );
   public static SqlBoolean operator  >  (SqlInt32   x   , SqlInt32   y   );
   public static SqlBoolean operator  >=  (SqlInt32   x   , SqlInt32   y   );
   public static explicit operator  int  ( SqlInt32   x   );  
   public static explicit operator  SqlInt32  ( SqlBoolean   x   );  
   public static explicit operator  SqlInt32  ( SqlDecimal   x   );  
   public static explicit operator  SqlInt32  ( SqlDouble   x   );  
   public static explicit operator  SqlInt32  ( SqlInt64   x   );  
   public static explicit operator  SqlInt32  ( SqlMoney   x   );  
   public static explicit operator  SqlInt32  ( SqlSingle   x   );  
   public static explicit operator  SqlInt32  ( SqlString   x   );  
   public static implicit operator  SqlInt32  ( int   x   );  
   public static implicit operator  SqlInt32  ( SqlByte   x   );  
   public static implicit operator  SqlInt32  ( SqlInt16   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 SqlBoolean  ToSqlBoolean  (  );  
   public SqlByte  ToSqlByte  (  );  
   public SqlDecimal  ToSqlDecimal  (  );  
   public SqlDouble  ToSqlDouble  (  );  
   public SqlInt16  ToSqlInt16  (  );  
   public SqlInt64  ToSqlInt64  (  );  
   public SqlMoney  ToSqlMoney  (  );  
   public SqlSingle  ToSqlSingle  (  );  
   public SqlString  ToSqlString  (  );  
   public override string  ToString  (  );  // overrides ValueType  } 

Hierarchy

System.Object figs/u2192.gif System.ValueType figs/u2192.gif SqlInt32(INullable, System.IComparable)

Returned By

System.Data.SqlClient.SqlDataReader.GetSqlInt32( ) , SqlBoolean.ToSqlInt32( ) , SqlByte.ToSqlInt32( ) , SqlDecimal.{Sign( ) , ToSqlInt32( )} , SqlDouble.ToSqlInt32( ) , SqlInt16.ToSqlInt32( ) , SqlInt64.ToSqlInt32( ) , SqlMoney.ToSqlInt32( ) , SqlSingle.ToSqlInt32( ) , SqlString.ToSqlInt32( )