SqlBoolean Structure

 

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)

[SerializableAttribute]
public struct SqlBoolean : INullable, IComparable, IXmlSerializable

NameDescription
System_CAPS_pubmethodSqlBoolean(Boolean)

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

System_CAPS_pubmethodSqlBoolean(Int32)

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

NameDescription
System_CAPS_pubpropertyByteValue

Gets the value of the SqlBoolean structure as a byte.

System_CAPS_pubpropertyIsFalse

Indicates whether the current Value is False.

System_CAPS_pubpropertyIsNull

Indicates whether this SqlBoolean structure is null.

System_CAPS_pubpropertyIsTrue

Indicates whether the current Value is True.

System_CAPS_pubpropertyValue

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

NameDescription
System_CAPS_pubmethodSystem_CAPS_staticAnd(SqlBoolean, SqlBoolean)

Computes the bitwise AND operation of two specified SqlBoolean structures.

System_CAPS_pubmethodCompareTo(Object)

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

System_CAPS_pubmethodCompareTo(SqlBoolean)

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

System_CAPS_pubmethodEquals(Object)

Compares the supplied object parameter to the SqlBoolean.(Overrides ValueType.Equals(Object).)

System_CAPS_pubmethodSystem_CAPS_staticEquals(SqlBoolean, SqlBoolean)

Compares two SqlBoolean structures to determine whether they are equal.

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Overrides ValueType.GetHashCode().)

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_pubmethodSystem_CAPS_staticGetXsdType(XmlSchemaSet)

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

System_CAPS_pubmethodSystem_CAPS_staticGreaterThan(SqlBoolean, SqlBoolean)

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

System_CAPS_pubmethodSystem_CAPS_staticGreaterThanOrEquals(SqlBoolean, SqlBoolean)

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

System_CAPS_pubmethodSystem_CAPS_staticLessThan(SqlBoolean, SqlBoolean)

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

System_CAPS_pubmethodSystem_CAPS_staticLessThanOrEquals(SqlBoolean, SqlBoolean)

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

System_CAPS_pubmethodSystem_CAPS_staticNotEquals(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean for equality.

System_CAPS_pubmethodSystem_CAPS_staticOnesComplement(SqlBoolean)

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

System_CAPS_pubmethodSystem_CAPS_staticOr(SqlBoolean, SqlBoolean)

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

System_CAPS_pubmethodSystem_CAPS_staticParse(String)

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

System_CAPS_pubmethodToSqlByte()

Converts this SqlBoolean structure to SqlByte.

System_CAPS_pubmethodToSqlDecimal()

Converts this SqlBoolean structure to SqlDecimal.

System_CAPS_pubmethodToSqlDouble()

Converts this SqlBoolean structure to SqlDouble.

System_CAPS_pubmethodToSqlInt16()

Converts this SqlBoolean structure to SqlInt16.

System_CAPS_pubmethodToSqlInt32()

Converts this SqlBoolean structure to SqlInt32.

System_CAPS_pubmethodToSqlInt64()

Converts this SqlBoolean structure to SqlInt64.

System_CAPS_pubmethodToSqlMoney()

Converts this SqlBoolean structure to SqlMoney.

System_CAPS_pubmethodToSqlSingle()

Converts this SqlBoolean structure to SqlSingle.

System_CAPS_pubmethodToSqlString()

Converts this SqlBoolean structure to SqlString.

System_CAPS_pubmethodToString()

Converts this SqlBoolean structure to a string.(Overrides ValueType.ToString().)

System_CAPS_pubmethodSystem_CAPS_staticXor(SqlBoolean, SqlBoolean)

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

NameDescription
System_CAPS_pubfieldSystem_CAPS_staticFalse

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

System_CAPS_pubfieldSystem_CAPS_staticNull

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

System_CAPS_pubfieldSystem_CAPS_staticOne

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

System_CAPS_pubfieldSystem_CAPS_staticTrue

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

System_CAPS_pubfieldSystem_CAPS_staticZero

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

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticBitwiseAnd(SqlBoolean, SqlBoolean)

Computes the bitwise AND operation of two specified SqlBoolean structures.

System_CAPS_puboperatorSystem_CAPS_staticBitwiseOr(SqlBoolean, SqlBoolean)

Computes the bitwise OR of its operands.

System_CAPS_puboperatorSystem_CAPS_staticEquality(SqlBoolean, SqlBoolean)

Compares two instances of SqlBoolean for equality.

System_CAPS_puboperatorSystem_CAPS_staticExclusiveOr(SqlBoolean, SqlBoolean)

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

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlBoolean to Boolean)

Converts a SqlBoolean to a Boolean.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlByte to SqlBoolean)

Converts the SqlByte parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlDecimal to SqlBoolean)

Converts the SqlDecimal parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlDouble to SqlBoolean)

Converts the SqlDouble parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlInt16 to SqlBoolean)

Converts the SqlInt16 parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlInt32 to SqlBoolean)

Converts the SqlInt32 parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlInt64 to SqlBoolean)

Converts the SqlInt64 parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlMoney to SqlBoolean)

Converts the SqlMoney parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlSingle to SqlBoolean)

Converts the SqlSingle parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlString to SqlBoolean)

Converts the SqlString parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticFalse(SqlBoolean)

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

System_CAPS_puboperatorSystem_CAPS_staticGreaterThan(SqlBoolean, SqlBoolean)

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

System_CAPS_puboperatorSystem_CAPS_staticGreaterThanOrEqual(SqlBoolean, SqlBoolean)

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

System_CAPS_puboperatorSystem_CAPS_staticImplicit(Boolean to SqlBoolean)

Converts the supplied byte value to a SqlBoolean.

System_CAPS_puboperatorSystem_CAPS_staticInequality(SqlBoolean, SqlBoolean)

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

System_CAPS_puboperatorSystem_CAPS_staticLessThan(SqlBoolean, SqlBoolean)

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

System_CAPS_puboperatorSystem_CAPS_staticLessThanOrEqual(SqlBoolean, SqlBoolean)

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

System_CAPS_puboperatorSystem_CAPS_staticLogicalNot(SqlBoolean)

Performs a NOT operation on a SqlBoolean.

System_CAPS_puboperatorSystem_CAPS_staticOnesComplement(SqlBoolean)

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

System_CAPS_puboperatorSystem_CAPS_staticTrue(SqlBoolean)

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

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.GetSchema()

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

System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.ReadXml(XmlReader)

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

System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.WriteXml(XmlWriter)

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

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
Available since 1.1

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show: