SqlDataRecord.GetBytes Method (Int32, Int64, Byte[], Int32, Int32)


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

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

public virtual long GetBytes(
	int ordinal,
	long fieldOffset,
	byte[] 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 bytes.

Type: System.Byte[]

The target buffer to which to copy bytes.

Type: System.Int32

The offset into the buffer to which to start copying bytes.

Type: System.Int32

The number of bytes to copy to the buffer.

Return Value

Type: System.Int64

The number of bytes 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 binary 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 byte array of the chunk-size and call GetBytes repeatedly, adjusting the fieldOffset parameter accordingly in each call.

.NET Framework
Available since 2.0
Return to top