Share via


SqlDataReader.GetStream(Int32) Method

Definition

Retrieves binary, image, varbinary, UDT, and variant data types as a Stream.

public:
 override System::IO::Stream ^ GetStream(int i);
public override System.IO.Stream GetStream(int i);
override this.GetStream : int -> System.IO.Stream
Public Overrides Function GetStream (i As Integer) As Stream

Parameters

i
Int32

The zero-based column ordinal.

Returns

A stream object.

Exceptions

Trying to read a column that does not exist.

The returned type was not one of the types below:

Remarks

ReadTimeout defaults to the value of CommandTimeout ; but you can modify ReadTimeout via GetStream.

Null values will be returned as an empty (zero bytes) Stream. GetBytes(Int32, Int64, Byte[], Int32, Int32) will raise an InvalidOperationException exception when used on an object returned by GetStream when SequentialAccess is in effect. SqlException exceptions raised from Stream are thrown as IOException exceptions; check the inner exception for the SqlException.

The following Stream members are not available for objects returned by GetStream:

For more information, see SqlClient Streaming Support

Applies to