GetTextReader Method

DbDataReader.GetTextReader Method (Int32)

.NET Framework 4.6 and 4.5

Retrieves data as a TextReader.

Namespace:   System.Data.Common
Assembly:  System.Data (in System.Data.dll)

public virtual TextReader GetTextReader(
	int ordinal


Type: System.Int32

Retrieves data as a TextReader.

Return Value

Type: System.IO.TextReader

The returned object.

Exception Condition

The connection drops or is closed during the data retrieval.

The DbDataReader is closed during the data retrieval.

There is no data ready to be read (for example, the first Read hasn't been called, or returned false).

Tried to read a previously-read column in sequential mode.

There was an asynchronous operation in progress. This applies to all Get* methods when running in sequential mode, as they could be called while reading a stream.


Trying to read a column that does not exist.


The returned type was not one of the types below:

  • char

  • nchar

  • ntext

  • nvarchar

  • text

  • varchar

GetTextReader only supports the retrieval of values that can be converted to character arrays (strings).

For more information, see SqlClient Streaming Support.

Universal Windows Platform
Available since 10
.NET Framework
Available since 4.5
Return to top
© 2015 Microsoft