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

SqlBoolean Structure

.NET Framework 4

Represents an integer value that is either 1 or 0 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 SqlBoolean : INullable, 
	IComparable, IXmlSerializable

The SqlBoolean type exposes the following members.

  Name Description
Public method Supported by the XNA Framework SqlBoolean(Boolean) Initializes a new instance of the SqlBoolean structure using the supplied Boolean value.
Public method Supported by the XNA Framework SqlBoolean(Int32) Initializes a new instance of the SqlBoolean structure using the specified integer value.
Top
  Name Description
Public property Supported by the XNA Framework ByteValue Gets the value of the SqlBoolean structure as a byte.
Public property Supported by the XNA Framework IsFalse Indicates whether the current Value is False.
Public property Supported by the XNA Framework IsNull Indicates whether this SqlBoolean structure is null.
Public property Supported by the XNA Framework IsTrue Indicates whether the current Value is True.
Public property Supported by the XNA Framework Value Gets the SqlBoolean structure's value. This property is read-only.
Top
  Name Description
Public method Static member Supported by the XNA Framework And Computes the bitwise AND operation of two specified SqlBoolean structures.
Public method Supported by the XNA Framework CompareTo(Object) Compares this SqlBoolean structure to a specified object and returns an indication of their relative values.
Public method Supported by the XNA Framework CompareTo(SqlBoolean) Compares this SqlBoolean object to the supplied SqlBoolean object and returns an indication of their relative values.
Public method Supported by the XNA Framework Equals(Object) Compares the supplied object parameter to the SqlBoolean. (Overrides ValueType.Equals(Object).)
Public method Static member Supported by the XNA Framework Equals(SqlBoolean, SqlBoolean) Compares two SqlBoolean structures 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 Returns 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 Compares two instances of SqlBoolean to determine whether the first is greater than the second.
Public method Static member Supported by the XNA Framework GreaterThanOrEquals Compares two instances of SqlBoolean to determine whether the first is greater than or equal to the second.
Public method Static member Supported by the XNA Framework LessThan Compares two instances of SqlBoolean to determine whether the first is less than the second.
Public method Static member Supported by the XNA Framework LessThanOrEquals Compares two instances of SqlBoolean 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 NotEquals Compares two instances of SqlBoolean for equality.
Public method Static member Supported by the XNA Framework OnesComplement Performs a one's complement operation on the supplied SqlBoolean structures.
Public method Static member Supported by the XNA Framework Or Performs a bitwise OR operation on the two specified SqlBoolean structures.
Public method Static member Supported by the XNA Framework Parse Converts the specified String representation of a logical value to its SqlBoolean equivalent.
Public method Supported by the XNA Framework ToSqlByte Converts this SqlBoolean structure to SqlByte.
Public method Supported by the XNA Framework ToSqlDecimal Converts this SqlBoolean structure to SqlDecimal.
Public method Supported by the XNA Framework ToSqlDouble Converts this SqlBoolean structure to SqlDouble.
Public method Supported by the XNA Framework ToSqlInt16 Converts this SqlBoolean structure to SqlInt16.
Public method Supported by the XNA Framework ToSqlInt32 Converts this SqlBoolean structure to SqlInt32.
Public method Supported by the XNA Framework ToSqlInt64 Converts this SqlBoolean structure to SqlInt64.
Public method Supported by the XNA Framework ToSqlMoney Converts this SqlBoolean structure to SqlMoney.
Public method Supported by the XNA Framework ToSqlSingle Converts this SqlBoolean structure to SqlSingle.
Public method Supported by the XNA Framework ToSqlString Converts this SqlBoolean structure to SqlString.
Public method Supported by the XNA Framework ToString Converts this SqlBoolean structure to a string. (Overrides ValueType.ToString().)
Public method Static member Supported by the XNA Framework Xor Performs a bitwise exclusive-OR operation on the supplied parameters.
Top
  Name Description
Public operator Static member Supported by the XNA Framework BitwiseAnd Computes the bitwise AND operation of two specified SqlBoolean structures.
Public operator Static member Supported by the XNA Framework BitwiseOr Computes the bitwise OR of its operands.
Public operator Static member Supported by the XNA Framework Equality Compares two instances of SqlBoolean for equality.
Public operator Static member Supported by the XNA Framework ExclusiveOr Performs a bitwise exclusive-OR (XOR) operation on the supplied parameters.
Public operator Static member Supported by the XNA Framework Explicit(SqlBoolean to Boolean) Converts a SqlBoolean to a Boolean.
Public operator Static member Supported by the XNA Framework Explicit(SqlByte to SqlBoolean) Converts the SqlByte parameter to a SqlBoolean structure.
Public operator Static member Supported by the XNA Framework Explicit(SqlDecimal to SqlBoolean) Converts the SqlDecimal parameter to a SqlBoolean structure.
Public operator Static member Supported by the XNA Framework Explicit(SqlDouble to SqlBoolean) Converts the SqlDouble parameter to a SqlBoolean structure.
Public operator Static member Supported by the XNA Framework Explicit(SqlInt16 to SqlBoolean) Converts the SqlInt16 parameter to a SqlBoolean structure.
Public operator Static member Supported by the XNA Framework Explicit(SqlInt32 to SqlBoolean) Converts the SqlInt32 parameter to a SqlBoolean structure.
Public operator Static member Supported by the XNA Framework Explicit(SqlInt64 to SqlBoolean) Converts the SqlInt64 parameter to a SqlBoolean structure.
Public operator Static member Supported by the XNA Framework Explicit(SqlMoney to SqlBoolean) Converts the SqlMoney parameter to a SqlBoolean structure.
Public operator Static member Supported by the XNA Framework Explicit(SqlSingle to SqlBoolean) Converts the SqlSingle parameter to a SqlBoolean structure.
Public operator Static member Supported by the XNA Framework Explicit(SqlString to SqlBoolean) Converts the SqlString parameter to a SqlBoolean structure.
Public operator Static member Supported by the XNA Framework False The false operator can be used to test the Value of the SqlBoolean to determine whether it is false.
Public operator Static member Supported by the XNA Framework GreaterThan Compares two SqlBoolean structures to determine whether the first is greater than the second.
Public operator Static member Supported by the XNA Framework GreaterThanOrEqual Compares two SqlBoolean structures to determine whether the first is greater than or equal to the second.
Public operator Static member Supported by the XNA Framework Implicit(Boolean to SqlBoolean) Converts the supplied byte value to a SqlBoolean.
Public operator Static member Supported by the XNA Framework Inequality Compares two instances of SqlBoolean to determine whether they are not equal.
Public operator Static member Supported by the XNA Framework LessThan Compares two instances of SqlBoolean to determine whether the first is less than the second.
Public operator Static member Supported by the XNA Framework LessThanOrEqual Compares two instances of SqlBoolean to determine whether the first is less than or equal to the second.
Public operator Static member Supported by the XNA Framework LogicalNot Performs a NOT operation on a SqlBoolean.
Public operator Static member Supported by the XNA Framework OnesComplement Performs a one's complement operation on the supplied SqlBoolean structures.
Public operator Static member Supported by the XNA Framework True The true operator can be used to test the Value of the SqlBoolean to determine whether it is true.
Top
  Name Description
Public field Static member Supported by the XNA Framework False Represents a false value that can be assigned to the Value property of an instance of the SqlBoolean structure.
Public field Static member Supported by the XNA Framework Null Represents DBNull that can be assigned to this instance of the SqlBoolean structure.
Public field Static member Supported by the XNA Framework One Represents a one value that can be assigned to the ByteValue property of an instance of the SqlBoolean structure.
Public field Static member Supported by the XNA Framework True Represents a true value that can be assigned to the Value property of an instance of the SqlBoolean structure.
Public field Static member Supported by the XNA Framework Zero Represents a zero value that can be assigned to the ByteValue property of an instance of the SqlBoolean structure.
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

Any non-zero value is interpreted as 1.

The key difference between a SqlBoolean structure and a standard Boolean value is that, where a standard Boolean has two possible values, true and false, a SqlBoolean structure has three possible values, True, False, or Null.

.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