SqlDataRecord.GetChars Method (Int32, Int64, Char[], Int32, Int32)


Gets the value for the column specified by the ordinal as an array of Char objects.

Namespace:   Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public virtual long GetChars(
	int ordinal,
	long fieldOffset,
	char[] buffer,
	int bufferOffset,
	int length


Type: System.Int32

The zero-based ordinal of the column.

Type: System.Int64

The offset into the field value to start retrieving characters.

Type: System.Char[]

The target buffer to copy chars to.

Type: System.Int32

The offset into the buffer to start copying chars to.

Type: System.Int32

The number of chars to copy to the buffer.

Return Value

Type: System.Int64

The number of characters copied.

Exception Condition

The ordinal is less than 0 or greater than the number of columns (that is, FieldCount).


The column specified by ordinal is null.


There is a type mismatch.

This method enables you to obtain a character value either in a single call or in chunks. Getting the value in chunks is useful for large values or values of unknown size.

To obtain the value in several chunks, allocate a char array of the chunk-size and call GetChars repeatedly adjusting the fieldOffset parameter accordingly in each call.

.NET Framework
Available since 2.0
Return to top