SqlBoolean SqlBoolean SqlBoolean 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
[System.Serializable]
public struct SqlBoolean : IComparable, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
type SqlBoolean = struct
    interface INullable
    interface IXmlSerializable
Public Structure SqlBoolean
Implements IComparable, INullable, IXmlSerializable
Inheritance
SqlBooleanSqlBooleanSqlBooleanSqlBoolean
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) SqlBoolean(Boolean) SqlBoolean(Boolean) SqlBoolean(Boolean)

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

SqlBoolean(Int32) SqlBoolean(Int32) SqlBoolean(Int32) SqlBoolean(Int32)

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

Fields

False False False False

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

Null Null Null Null

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

One One One One

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

True True True True

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

Zero Zero Zero Zero

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

Properties

ByteValue ByteValue ByteValue ByteValue

Gets the value of the SqlBoolean structure as a byte.

IsFalse IsFalse IsFalse IsFalse

Indicates whether the current Value is False.

IsNull IsNull IsNull IsNull

Indicates whether this SqlBoolean structure is null.

IsTrue IsTrue IsTrue IsTrue

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

Value Value Value Value

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

Methods

And(SqlBoolean, SqlBoolean) And(SqlBoolean, SqlBoolean) And(SqlBoolean, SqlBoolean) And(SqlBoolean, SqlBoolean)

Computes the bitwise AND operation of two specified SqlBoolean structures.

CompareTo(SqlBoolean) CompareTo(SqlBoolean) CompareTo(SqlBoolean) CompareTo(SqlBoolean)

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

CompareTo(Object) CompareTo(Object) CompareTo(Object) CompareTo(Object)

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

Equals(Object) Equals(Object) Equals(Object) Equals(Object)

Compares the supplied object parameter to the SqlBoolean.

Equals(SqlBoolean, SqlBoolean) Equals(SqlBoolean, SqlBoolean) Equals(SqlBoolean, SqlBoolean) Equals(SqlBoolean, SqlBoolean)

Compares two SqlBoolean structures to determine whether they are equal.

GetHashCode() GetHashCode() GetHashCode() GetHashCode()

Returns the hash code for this instance.

GetXsdType(XmlSchemaSet) GetXsdType(XmlSchemaSet) GetXsdType(XmlSchemaSet) GetXsdType(XmlSchemaSet)

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

GreaterThan(SqlBoolean, SqlBoolean) GreaterThan(SqlBoolean, SqlBoolean) GreaterThan(SqlBoolean, SqlBoolean) GreaterThan(SqlBoolean, SqlBoolean)

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

GreaterThanOrEquals(SqlBoolean, SqlBoolean) GreaterThanOrEquals(SqlBoolean, SqlBoolean) GreaterThanOrEquals(SqlBoolean, SqlBoolean) GreaterThanOrEquals(SqlBoolean, SqlBoolean)

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

LessThan(SqlBoolean, SqlBoolean) LessThan(SqlBoolean, SqlBoolean) LessThan(SqlBoolean, SqlBoolean) LessThan(SqlBoolean, SqlBoolean)

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

LessThanOrEquals(SqlBoolean, SqlBoolean) LessThanOrEquals(SqlBoolean, SqlBoolean) LessThanOrEquals(SqlBoolean, SqlBoolean) LessThanOrEquals(SqlBoolean, SqlBoolean)

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

NotEquals(SqlBoolean, SqlBoolean) NotEquals(SqlBoolean, SqlBoolean) NotEquals(SqlBoolean, SqlBoolean) NotEquals(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean for equality.

OnesComplement(SqlBoolean) OnesComplement(SqlBoolean) OnesComplement(SqlBoolean) OnesComplement(SqlBoolean)

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

Or(SqlBoolean, SqlBoolean) Or(SqlBoolean, SqlBoolean) Or(SqlBoolean, SqlBoolean) Or(SqlBoolean, SqlBoolean)

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

Parse(String) Parse(String) Parse(String) Parse(String)

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

ToSqlByte() ToSqlByte() ToSqlByte() ToSqlByte()

Converts this SqlBoolean structure to SqlByte.

ToSqlDecimal() ToSqlDecimal() ToSqlDecimal() ToSqlDecimal()

Converts this SqlBoolean structure to SqlDecimal.

ToSqlDouble() ToSqlDouble() ToSqlDouble() ToSqlDouble()

Converts this SqlBoolean structure to SqlDouble.

ToSqlInt16() ToSqlInt16() ToSqlInt16() ToSqlInt16()

Converts this SqlBoolean structure to SqlInt16.

ToSqlInt32() ToSqlInt32() ToSqlInt32() ToSqlInt32()

Converts this SqlBoolean structure to SqlInt32.

ToSqlInt64() ToSqlInt64() ToSqlInt64() ToSqlInt64()

Converts this SqlBoolean structure to SqlInt64.

ToSqlMoney() ToSqlMoney() ToSqlMoney() ToSqlMoney()

Converts this SqlBoolean structure to SqlMoney.

ToSqlSingle() ToSqlSingle() ToSqlSingle() ToSqlSingle()

Converts this SqlBoolean structure to SqlSingle.

ToSqlString() ToSqlString() ToSqlString() ToSqlString()

Converts this SqlBoolean structure to SqlString.

ToString() ToString() ToString() ToString()

Converts this SqlBoolean structure to a string.

Xor(SqlBoolean, SqlBoolean) Xor(SqlBoolean, SqlBoolean) Xor(SqlBoolean, SqlBoolean) Xor(SqlBoolean, SqlBoolean)

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

Operators

BitwiseAnd(SqlBoolean, SqlBoolean) BitwiseAnd(SqlBoolean, SqlBoolean) BitwiseAnd(SqlBoolean, SqlBoolean) BitwiseAnd(SqlBoolean, SqlBoolean)

Computes the bitwise AND operation of two specified SqlBoolean structures.

BitwiseOr(SqlBoolean, SqlBoolean) BitwiseOr(SqlBoolean, SqlBoolean) BitwiseOr(SqlBoolean, SqlBoolean) BitwiseOr(SqlBoolean, SqlBoolean)

Computes the bitwise OR of its operands.

Equality(SqlBoolean, SqlBoolean) Equality(SqlBoolean, SqlBoolean) Equality(SqlBoolean, SqlBoolean) Equality(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean for equality.

ExclusiveOr(SqlBoolean, SqlBoolean) ExclusiveOr(SqlBoolean, SqlBoolean) ExclusiveOr(SqlBoolean, SqlBoolean) ExclusiveOr(SqlBoolean, SqlBoolean)

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

Explicit(SqlString to SqlBoolean) Explicit(SqlString to SqlBoolean) Explicit(SqlString to SqlBoolean) Explicit(SqlString to SqlBoolean)

Converts the SqlString parameter to a SqlBoolean structure.

Explicit(SqlSingle to SqlBoolean) Explicit(SqlSingle to SqlBoolean) Explicit(SqlSingle to SqlBoolean) Explicit(SqlSingle to SqlBoolean)

Converts the SqlSingle parameter to a SqlBoolean structure.

Explicit(SqlMoney to SqlBoolean) Explicit(SqlMoney to SqlBoolean) Explicit(SqlMoney to SqlBoolean) Explicit(SqlMoney to SqlBoolean)

Converts the SqlMoney parameter to a SqlBoolean structure.

Explicit(SqlInt32 to SqlBoolean) Explicit(SqlInt32 to SqlBoolean) Explicit(SqlInt32 to SqlBoolean) Explicit(SqlInt32 to SqlBoolean)

Converts the SqlInt32 parameter to a SqlBoolean structure.

Explicit(SqlInt64 to SqlBoolean) Explicit(SqlInt64 to SqlBoolean) Explicit(SqlInt64 to SqlBoolean) Explicit(SqlInt64 to SqlBoolean)

Converts the SqlInt64 parameter to a SqlBoolean structure.

Explicit(SqlDouble to SqlBoolean) Explicit(SqlDouble to SqlBoolean) Explicit(SqlDouble to SqlBoolean) Explicit(SqlDouble to SqlBoolean)

Converts the SqlDouble parameter to a SqlBoolean structure.

Explicit(SqlInt16 to SqlBoolean) Explicit(SqlInt16 to SqlBoolean) Explicit(SqlInt16 to SqlBoolean) Explicit(SqlInt16 to SqlBoolean)

Converts the SqlInt16 parameter to a SqlBoolean structure.

Explicit(SqlDecimal to SqlBoolean) Explicit(SqlDecimal to SqlBoolean) Explicit(SqlDecimal to SqlBoolean) Explicit(SqlDecimal to SqlBoolean)

Converts the SqlDecimal parameter to a SqlBoolean structure.

Explicit(SqlByte to SqlBoolean) Explicit(SqlByte to SqlBoolean) Explicit(SqlByte to SqlBoolean) Explicit(SqlByte to SqlBoolean)

Converts the SqlByte parameter to a SqlBoolean structure.

Explicit(SqlBoolean to Boolean) Explicit(SqlBoolean to Boolean) Explicit(SqlBoolean to Boolean) Explicit(SqlBoolean to Boolean)

Converts a SqlBoolean to a Boolean.

False(SqlBoolean) False(SqlBoolean) False(SqlBoolean) False(SqlBoolean)

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

GreaterThan(SqlBoolean, SqlBoolean) GreaterThan(SqlBoolean, SqlBoolean) GreaterThan(SqlBoolean, SqlBoolean) GreaterThan(SqlBoolean, SqlBoolean)

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

GreaterThanOrEqual(SqlBoolean, SqlBoolean) GreaterThanOrEqual(SqlBoolean, SqlBoolean) GreaterThanOrEqual(SqlBoolean, SqlBoolean) GreaterThanOrEqual(SqlBoolean, SqlBoolean)

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

Implicit(Boolean to SqlBoolean) Implicit(Boolean to SqlBoolean) Implicit(Boolean to SqlBoolean) Implicit(Boolean to SqlBoolean)

Converts the supplied byte value to a SqlBoolean.

Inequality(SqlBoolean, SqlBoolean) Inequality(SqlBoolean, SqlBoolean) Inequality(SqlBoolean, SqlBoolean) Inequality(SqlBoolean, SqlBoolean)

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

LessThan(SqlBoolean, SqlBoolean) LessThan(SqlBoolean, SqlBoolean) LessThan(SqlBoolean, SqlBoolean) LessThan(SqlBoolean, SqlBoolean)

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

LessThanOrEqual(SqlBoolean, SqlBoolean) LessThanOrEqual(SqlBoolean, SqlBoolean) LessThanOrEqual(SqlBoolean, SqlBoolean) LessThanOrEqual(SqlBoolean, SqlBoolean)

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

LogicalNot(SqlBoolean) LogicalNot(SqlBoolean) LogicalNot(SqlBoolean) LogicalNot(SqlBoolean)

Performs a NOT operation on a SqlBoolean.

OnesComplement(SqlBoolean) OnesComplement(SqlBoolean) OnesComplement(SqlBoolean) OnesComplement(SqlBoolean)

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

True(SqlBoolean) True(SqlBoolean) True(SqlBoolean) 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() IXmlSerializable.GetSchema() IXmlSerializable.GetSchema() IXmlSerializable.GetSchema()

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

IXmlSerializable.ReadXml(XmlReader) IXmlSerializable.ReadXml(XmlReader) IXmlSerializable.ReadXml(XmlReader) IXmlSerializable.ReadXml(XmlReader)

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

IXmlSerializable.WriteXml(XmlWriter) IXmlSerializable.WriteXml(XmlWriter) IXmlSerializable.WriteXml(XmlWriter) 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