SqlString Constructors

Reference

Definition

Namespace:: System.Data.SqlTypes

Assemblies:: netstandard.dll, System.Data.Common.dll

Assembly:: System.Data.SqlClient.dll

Assembly:: System.Data.Common.dll

Assembly:: System.Data.dll

Assembly:: netstandard.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Initializes a new instance of the SqlString class.

Overloads

SqlString(String)	Initializes a new instance of the SqlString structure using the specified string.
SqlString(String, Int32)	Initializes a new instance of the SqlString structure using the specified string and locale id values.
SqlString(Int32, SqlCompareOptions, Byte[])	Initializes a new instance of the SqlString structure using the specified locale id, compare options, and data.
SqlString(String, Int32, SqlCompareOptions)	Initializes a new instance of the SqlString structure using the specified string, locale id, and compare option values.
SqlString(Int32, SqlCompareOptions, Byte[], Boolean)	Initializes a new instance of the SqlString class.
SqlString(Int32, SqlCompareOptions, Byte[], Int32, Int32)	Initializes a new instance of the SqlString class.
SqlString(Int32, SqlCompareOptions, Byte[], Int32, Int32, Boolean)	Initializes a new instance of the SqlString class.

SqlString(String)

Source:: SQLString.cs

Source:: SQLString.cs

Source:: SQLString.cs

Initializes a new instance of the SqlString structure using the specified string.

public:
 SqlString(System::String ^ data);

public SqlString(string? data);

public SqlString(string data);

new System.Data.SqlTypes.SqlString : string -> System.Data.SqlTypes.SqlString

Public Sub New (data As String)

Parameters

data: String

The string to store.

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

SqlString(String, Int32)

Source:: SQLString.cs

Source:: SQLString.cs

Source:: SQLString.cs

Initializes a new instance of the SqlString structure using the specified string and locale id values.

public:
 SqlString(System::String ^ data, int lcid);

public SqlString(string? data, int lcid);

public SqlString(string data, int lcid);

new System.Data.SqlTypes.SqlString : string * int -> System.Data.SqlTypes.SqlString

Public Sub New (data As String, lcid As Integer)

Parameters

data: String

The string to store.

lcid: Int32

Specifies the geographical locale and language for the new SqlString structure.

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

SqlString(Int32, SqlCompareOptions, Byte[])

Source:: SQLString.cs

Source:: SQLString.cs

Source:: SQLString.cs

Initializes a new instance of the SqlString structure using the specified locale id, compare options, and data.

public:
 SqlString(int lcid, System::Data::SqlTypes::SqlCompareOptions compareOptions, cli::array <System::Byte> ^ data);

public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[] data);

new System.Data.SqlTypes.SqlString : int * System.Data.SqlTypes.SqlCompareOptions * byte[] -> System.Data.SqlTypes.SqlString

Public Sub New (lcid As Integer, compareOptions As SqlCompareOptions, data As Byte())

Parameters

lcid: Int32

Specifies the geographical locale and language for the new SqlString structure.

compareOptions: SqlCompareOptions

Specifies the compare options for the new SqlString structure.

data: Byte[]

The data array to store.

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

SqlString(String, Int32, SqlCompareOptions)

Source:: SQLString.cs

Source:: SQLString.cs

Source:: SQLString.cs

Initializes a new instance of the SqlString structure using the specified string, locale id, and compare option values.

public:
 SqlString(System::String ^ data, int lcid, System::Data::SqlTypes::SqlCompareOptions compareOptions);

public SqlString(string? data, int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions);

public SqlString(string data, int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions);

new System.Data.SqlTypes.SqlString : string * int * System.Data.SqlTypes.SqlCompareOptions -> System.Data.SqlTypes.SqlString

Public Sub New (data As String, lcid As Integer, compareOptions As SqlCompareOptions)

Parameters

data: String

The string to store.

lcid: Int32

Specifies the geographical locale and language for the new SqlString structure.

compareOptions: SqlCompareOptions

Specifies the compare options for the new SqlString structure.

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

SqlString(Int32, SqlCompareOptions, Byte[], Boolean)

Source:: SQLString.cs

Source:: SQLString.cs

Source:: SQLString.cs

Initializes a new instance of the SqlString class.

public:
 SqlString(int lcid, System::Data::SqlTypes::SqlCompareOptions compareOptions, cli::array <System::Byte> ^ data, bool fUnicode);

public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[] data, bool fUnicode);

new System.Data.SqlTypes.SqlString : int * System.Data.SqlTypes.SqlCompareOptions * byte[] * bool -> System.Data.SqlTypes.SqlString

Public Sub New (lcid As Integer, compareOptions As SqlCompareOptions, data As Byte(), fUnicode As Boolean)

Parameters

lcid: Int32

Specifies the geographical locale and language for the new SqlString structure.

compareOptions: SqlCompareOptions

Specifies the compare options for the new SqlString structure.

data: Byte[]

The data array to store.

fUnicode: Boolean

true if Unicode encoded. Otherwise, false.

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

SqlString(Int32, SqlCompareOptions, Byte[], Int32, Int32)

Source:: SQLString.cs

Source:: SQLString.cs

Source:: SQLString.cs

Initializes a new instance of the SqlString class.

public:
 SqlString(int lcid, System::Data::SqlTypes::SqlCompareOptions compareOptions, cli::array <System::Byte> ^ data, int index, int count);

public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[]? data, int index, int count);

public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[] data, int index, int count);

new System.Data.SqlTypes.SqlString : int * System.Data.SqlTypes.SqlCompareOptions * byte[] * int * int -> System.Data.SqlTypes.SqlString

Public Sub New (lcid As Integer, compareOptions As SqlCompareOptions, data As Byte(), index As Integer, count As Integer)

Parameters

lcid: Int32

Specifies the geographical locale and language for the new SqlString structure.

compareOptions: SqlCompareOptions

Specifies the compare options for the new SqlString structure.

data: Byte[]

The data array to store.

index: Int32

The starting index within the array.

count: Int32

The number of characters from index to copy.

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

SqlString(Int32, SqlCompareOptions, Byte[], Int32, Int32, Boolean)

Source:: SQLString.cs

Source:: SQLString.cs

Source:: SQLString.cs

Initializes a new instance of the SqlString class.

public:
 SqlString(int lcid, System::Data::SqlTypes::SqlCompareOptions compareOptions, cli::array <System::Byte> ^ data, int index, int count, bool fUnicode);

public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[]? data, int index, int count, bool fUnicode);

public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[] data, int index, int count, bool fUnicode);

new System.Data.SqlTypes.SqlString : int * System.Data.SqlTypes.SqlCompareOptions * byte[] * int * int * bool -> System.Data.SqlTypes.SqlString

Public Sub New (lcid As Integer, compareOptions As SqlCompareOptions, data As Byte(), index As Integer, count As Integer, fUnicode As Boolean)

Parameters

lcid: Int32

Specifies the geographical locale and language for the new SqlString structure.

compareOptions: SqlCompareOptions

Specifies the compare options for the new SqlString structure.

data: Byte[]

The data array to store.

index: Int32

The starting index within the array.

count: Int32

The number of characters from index to copy.

fUnicode: Boolean

true if Unicode encoded. Otherwise, false.

Applies to

.NET 10 and other versions

Product	Versions
.NET	Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0, 2.1

Share via

SqlString Constructors

Definition

Overloads

SqlString(String)

Parameters

See also

Applies to

SqlString(String, Int32)

Parameters

See also

Applies to

SqlString(Int32, SqlCompareOptions, Byte[])

Parameters

See also

Applies to

SqlString(String, Int32, SqlCompareOptions)

Parameters

See also

Applies to

SqlString(Int32, SqlCompareOptions, Byte[], Boolean)

Parameters

See also

Applies to

SqlString(Int32, SqlCompareOptions, Byte[], Int32, Int32)

Parameters

See also

Applies to

SqlString(Int32, SqlCompareOptions, Byte[], Int32, Int32, Boolean)

Parameters

See also

Applies to

Additional resources