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 Structure SqlBoolean
	Implements 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_staticNarrowing(SqlBoolean to Boolean)

Converts a SqlBoolean to a Boolean.

System_CAPS_puboperatorSystem_CAPS_staticNarrowing(SqlByte to SqlBoolean)

Converts the SqlByte parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticNarrowing(SqlDecimal to SqlBoolean)

Converts the SqlDecimal parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticNarrowing(SqlDouble to SqlBoolean)

Converts the SqlDouble parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticNarrowing(SqlInt16 to SqlBoolean)

Converts the SqlInt16 parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticNarrowing(SqlInt32 to SqlBoolean)

Converts the SqlInt32 parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticNarrowing(SqlInt64 to SqlBoolean)

Converts the SqlInt64 parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticNarrowing(SqlMoney to SqlBoolean)

Converts the SqlMoney parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticNarrowing(SqlSingle to SqlBoolean)

Converts the SqlSingle parameter to a SqlBoolean structure.

System_CAPS_puboperatorSystem_CAPS_staticNarrowing(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_staticWidening(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: