SqlBoolean Struct

Definition

Represents an integer value that is either 1 or 0 to be stored in or retrieved from a database.

public value class SqlBoolean : IComparable, System::Data::SqlTypes::INullable, System::Xml::Serialization::IXmlSerializable
public value class SqlBoolean : IComparable, IEquatable<System::Data::SqlTypes::SqlBoolean>, System::Data::SqlTypes::INullable, System::Xml::Serialization::IXmlSerializable
public value class SqlBoolean : IComparable, System::Data::SqlTypes::INullable
public struct SqlBoolean : IComparable, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
public struct SqlBoolean : IComparable, IEquatable<System.Data.SqlTypes.SqlBoolean>, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
public struct SqlBoolean : IComparable, System.Data.SqlTypes.INullable
[System.Serializable]
public struct SqlBoolean : IComparable, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
type SqlBoolean = struct
    interface INullable
    interface IXmlSerializable
type SqlBoolean = struct
    interface INullable
[<System.Serializable>]
type SqlBoolean = struct
    interface INullable
    interface IXmlSerializable
Public Structure SqlBoolean
Implements IComparable, INullable, IXmlSerializable
Public Structure SqlBoolean
Implements IComparable, IEquatable(Of SqlBoolean), INullable, IXmlSerializable
Public Structure SqlBoolean
Implements IComparable, INullable
Inheritance
SqlBoolean
Attributes
Implements

Remarks

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.

Constructors

SqlBoolean(Boolean)

Initializes a new instance of the SqlBoolean structure using the supplied Boolean value.

SqlBoolean(Int32)

Initializes a new instance of the SqlBoolean structure using the specified integer value.

Fields

False

Represents a false value that can be assigned to the Value property of an instance of the SqlBoolean structure.

Null

Represents DBNull that can be assigned to this instance of the SqlBoolean structure.

One

Represents a one value that can be assigned to the ByteValue property of an instance of the SqlBoolean structure.

True

Represents a true value that can be assigned to the Value property of an instance of the SqlBoolean structure.

Zero

Represents a zero value that can be assigned to the ByteValue property of an instance of the SqlBoolean structure.

Properties

ByteValue

Gets the value of the SqlBoolean structure as a byte.

IsFalse

Indicates whether the current Value is False.

IsNull

Indicates whether this SqlBoolean structure is null.

IsTrue

Gets a value that indicates whether the current Value is True.

Value

Gets the SqlBoolean structure's value. This property is read-only.

Methods

And(SqlBoolean, SqlBoolean)

Computes the bitwise AND operation of two specified SqlBoolean structures.

CompareTo(Object)

Compares this SqlBoolean structure to a specified object and returns an indication of their relative values.

CompareTo(SqlBoolean)

Compares this SqlBoolean object to the supplied SqlBoolean object and returns an indication of their relative values.

Equals(Object)

Compares the supplied object parameter to the SqlBoolean.

Equals(SqlBoolean, SqlBoolean)

Compares two SqlBoolean structures to determine whether they are equal.

Equals(SqlBoolean)

Indicates whether the current instance is equal to another instance of the same type.

GetHashCode()

Returns the hash code for this instance.

GetXsdType(XmlSchemaSet)

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

GreaterThan(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean to determine whether the first is greater than the second.

GreaterThanOrEquals(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean to determine whether the first is greater than or equal to the second.

LessThan(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean to determine whether the first is less than the second.

LessThanOrEquals(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean to determine whether the first is less than or equal to the second.

NotEquals(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean for equality.

OnesComplement(SqlBoolean)

Performs a one's complement operation on the supplied SqlBoolean structures.

Or(SqlBoolean, SqlBoolean)

Performs a bitwise OR operation on the two specified SqlBoolean structures.

Parse(String)

Converts the specified String representation of a logical value to its SqlBoolean equivalent.

ToSqlByte()

Converts this SqlBoolean structure to SqlByte.

ToSqlDecimal()

Converts this SqlBoolean structure to SqlDecimal.

ToSqlDouble()

Converts this SqlBoolean structure to SqlDouble.

ToSqlInt16()

Converts this SqlBoolean structure to SqlInt16.

ToSqlInt32()

Converts this SqlBoolean structure to SqlInt32.

ToSqlInt64()

Converts this SqlBoolean structure to SqlInt64.

ToSqlMoney()

Converts this SqlBoolean structure to SqlMoney.

ToSqlSingle()

Converts this SqlBoolean structure to SqlSingle.

ToSqlString()

Converts this SqlBoolean structure to SqlString.

ToString()

Converts this SqlBoolean structure to a string.

Xor(SqlBoolean, SqlBoolean)

Performs a bitwise exclusive-OR operation on the supplied parameters.

Operators

BitwiseAnd(SqlBoolean, SqlBoolean)

Computes the bitwise AND operation of two specified SqlBoolean structures.

BitwiseOr(SqlBoolean, SqlBoolean)

Computes the bitwise OR of its operands.

Equality(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean for equality.

ExclusiveOr(SqlBoolean, SqlBoolean)

Performs a bitwise exclusive-OR (XOR) operation on the supplied parameters.

Explicit(SqlBoolean to Boolean)

Converts a SqlBoolean to a Boolean.

Explicit(SqlByte to SqlBoolean)

Converts the SqlByte parameter to a SqlBoolean structure.

Explicit(SqlDecimal to SqlBoolean)

Converts the SqlDecimal parameter to a SqlBoolean structure.

Explicit(SqlDouble to SqlBoolean)

Converts the SqlDouble parameter to a SqlBoolean structure.

Explicit(SqlInt16 to SqlBoolean)

Converts the SqlInt16 parameter to a SqlBoolean structure.

Explicit(SqlInt32 to SqlBoolean)

Converts the SqlInt32 parameter to a SqlBoolean structure.

Explicit(SqlInt64 to SqlBoolean)

Converts the SqlInt64 parameter to a SqlBoolean structure.

Explicit(SqlMoney to SqlBoolean)

Converts the SqlMoney parameter to a SqlBoolean structure.

Explicit(SqlSingle to SqlBoolean)

Converts the SqlSingle parameter to a SqlBoolean structure.

Explicit(SqlString to SqlBoolean)

Converts the SqlString parameter to a SqlBoolean structure.

False(SqlBoolean)

The false operator can be used to test the Value of the SqlBoolean to determine whether it is false.

GreaterThan(SqlBoolean, SqlBoolean)

Compares two SqlBoolean structures to determine whether the first is greater than the second.

GreaterThanOrEqual(SqlBoolean, SqlBoolean)

Compares two SqlBoolean structures to determine whether the first is greater than or equal to the second.

Implicit(Boolean to SqlBoolean)

Converts the supplied byte value to a SqlBoolean.

Inequality(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean to determine whether they are not equal.

LessThan(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean to determine whether the first is less than the second.

LessThanOrEqual(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean to determine whether the first is less than or equal to the second.

LogicalNot(SqlBoolean)

Performs a NOT operation on a SqlBoolean.

OnesComplement(SqlBoolean)

Performs a one's complement operation on the supplied SqlBoolean structures.

True(SqlBoolean)

The true operator can be used to test the Value of the SqlBoolean to determine whether it is true.

Explicit Interface Implementations

IXmlSerializable.GetSchema()

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

IXmlSerializable.ReadXml(XmlReader)

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

IXmlSerializable.WriteXml(XmlWriter)

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

Applies to

See also