.NET Framework Class Library  

SqlString Members

SqlString overview

Public Constructors

public constructorSqlString Constructor

Supported by the .NET Compact Framework.

Overloaded. Initializes a new instance of the SqlString class.

Public Fields

public fieldstatic (Shared in Visual Basic)BinarySort

Supported by the .NET Compact Framework.

Specifies that sorts should be based on a characters numeric value rather than its alphabetic value.
public fieldstatic (Shared in Visual Basic)IgnoreCase

Supported by the .NET Compact Framework.

Specifies that SqlString comparisons should ignore case.
public fieldstatic (Shared in Visual Basic)IgnoreKanaType

Supported by the .NET Compact Framework.

Specifies that the string comparison must ignore the Kana type. Kana type refers to Japanese hiragana and katakana characters, which represent phonetic sounds in the Japanese language. Hiragana is used for native Japanese expressions and words, while katakana is used for words borrowed from other languages, such as "computer" or "internet". A phonetic sound can be expressed in both hiragana and katakana. If this value is selected, the hiragana character for one sound is considered equal to the katakana character for the same sound.
public fieldstatic (Shared in Visual Basic)IgnoreNonSpace

Supported by the .NET Compact Framework.

Specifies that the string comparison must ignore nonspace combining characters, such as diacritics. The Unicode Standard defines combining characters as characters that are combined with base characters to produce a new character. Non-space combining characters do not take up character space by themselves when rendered. For more information on non-space combining characters, see the Unicode Standard at http://www.unicode.org.
public fieldstatic (Shared in Visual Basic)IgnoreWidth

Supported by the .NET Compact Framework.

Specifies that the string comparison must ignore the character width. For example, Japanese katakana characters can be written as full-width or half-width and, if this value is selected, the katakana characters written as full-width are considered equal to the same characters written in half-width.
public fieldstatic (Shared in Visual Basic)Null

Supported by the .NET Compact Framework.

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

Public Properties

public propertyCompareInfo

Supported by the .NET Compact Framework.

Gets the CompareInfo object that defines how string comparisons should be performed for this SqlString structure.
public propertyCultureInfo

Supported by the .NET Compact Framework.

Gets the CultureInfo structure that represents information about the culture of this SqlString object.
public propertyIsNull

Supported by the .NET Compact Framework.

Indicates whether the Value of the SqlString is Null.
public propertyLCID

Supported by the .NET Compact Framework.

Specifies the geographical locale and language for the SqlString structure.
public propertySqlCompareOptions

Supported by the .NET Compact Framework.

A combination of one or more of the SqlCompareOptions enumeration values that represent the way in which this SqlString should be compared to other SqlString structures.
public propertyValue

Supported by the .NET Compact Framework.

Gets the string that is stored in this SqlString structure. This property is read-only.

Public Methods

public methodClone

Supported by the .NET Compact Framework.

Creates a copy of this SqlString object.
public methodstatic (Shared in Visual Basic)CompareOptionsFromSqlCompareOptions

Supported by the .NET Compact Framework.

Gets the CompareOptions enumeration equilvalent of the specified SqlCompareOptions value.
public methodCompareTo

Supported by the .NET Compact Framework.

Compares this instance of SqlString to the supplied object and returns an indication of their relative values.
public methodstatic (Shared in Visual Basic)Concat

Supported by the .NET Compact Framework.

Concatenates the two specified SqlString structures.
public methodEquals

Supported by the .NET Compact Framework.

Overloaded.
public methodGetHashCode

Supported by the .NET Compact Framework.

Overridden. Gets the hash code for this instance.
public methodGetNonUnicodeBytes

Supported by the .NET Compact Framework.

Gets an array of bytes, containing the contents of the SqlString in ANSI format.
public methodGetType (inherited from Object)

Supported by the .NET Compact Framework.

Gets the Type of the current instance.
public methodGetUnicodeBytes

Supported by the .NET Compact Framework.

Gets an array of bytes, containing the contents of the SqlString in Unicode format.
public methodstatic (Shared in Visual Basic)GreaterThan

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if the first is greater than the second.
public methodstatic (Shared in Visual Basic)GreaterThanOrEqual

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if the first is greater than or equal to the second.
public methodstatic (Shared in Visual Basic)LessThan

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if the first is less than the second.
public methodstatic (Shared in Visual Basic)LessThanOrEqual

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if the first is less than or equal to the second.
public methodstatic (Shared in Visual Basic)NotEquals

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if they are not equal.
public methodToSqlBoolean

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlBoolean.
public methodToSqlByte

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlByte.
public methodToSqlDateTime

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlDateTime.
public methodToSqlDecimal

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlDecimal.
public methodToSqlDouble

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlDouble.
public methodToSqlGuid

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlGuid.
public methodToSqlInt16

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlInt16.
public methodToSqlInt32

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlInt32.
public methodToSqlInt64

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlInt64.
public methodToSqlMoney

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlMoney.
public methodToSqlSingle

Supported by the .NET Compact Framework.

Converts this SqlString structure to SqlSingle.
public methodToString

Supported by the .NET Compact Framework.

Overridden. Converts a SqlString object to a String.

Public Operators and Type Conversions

public operatorstatic (Shared in Visual Basic)Addition Operator

Supported by the .NET Compact Framework.

Concatenates the two specified SqlString structures.
public operatorstatic (Shared in Visual Basic)Equality Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if they are equal.
public operatorstatic (Shared in Visual Basic)Greater Than Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if the first is greater than the second.
public operatorstatic (Shared in Visual Basic)Greater Than Or Equal Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if the first is greater than or equal to the second.
public operatorstatic (Shared in Visual Basic)Inequality Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if they are not equal.
public operatorstatic (Shared in Visual Basic)Less Than Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if the first is less than the second.
public operatorstatic (Shared in Visual Basic)Less Than Or Equal Operator

Supported by the .NET Compact Framework.

Performs a logical comparison of the two SqlString operands to determine if the first is less than or equal to the second.
public operatorstatic (Shared in Visual Basic)SqlBoolean to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlBoolean structure to SqlString.
public operatorstatic (Shared in Visual Basic)SqlByte to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlByte structure to SqlString.
public operatorstatic (Shared in Visual Basic)SqlDateTime to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlDateTime parameter to SqlString.
public operatorstatic (Shared in Visual Basic)SqlDecimal to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlDecimal parameter to SqlString.
public operatorstatic (Shared in Visual Basic)SqlDouble to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlDouble parameter to SqlString.
public operatorstatic (Shared in Visual Basic)SqlGuid to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlGuid parameter to SqlString.
public operatorstatic (Shared in Visual Basic)SqlInt16 to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlInt16 parameter to SqlString.
public operatorstatic (Shared in Visual Basic)SqlInt32 to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlInt32 parameter to SqlString.
public operatorstatic (Shared in Visual Basic)SqlInt64 to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlInt64 parameter to SqlString.
public operatorstatic (Shared in Visual Basic)SqlMoney to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlMoney parameter to SqlString.
public operatorstatic (Shared in Visual Basic)SqlSingle to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the specified SqlSingle parameter to SqlString.
public operatorstatic (Shared in Visual Basic)SqlString to String Conversion

Supported by the .NET Compact Framework.

Converts a SqlString to a String
public operatorstatic (Shared in Visual Basic)String to SqlString Conversion

Supported by the .NET Compact Framework.

Converts the String parameter to a SqlString.

Protected Methods

protected methodFinalize (inherited from Object)

Supported by the .NET Compact Framework.

Overridden. Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

In C# and C++, finalizers are expressed using destructor syntax.

protected methodMemberwiseClone (inherited from Object)

Supported by the .NET Compact Framework.

Creates a shallow copy of the current Object.

See Also

SqlString Structure | System.Data.SqlTypes Namespace