Windows apps
Collapse the table of content
Expand the table of content
Information
Switch
Switch
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

SqlDataReader::GetTextReader Method (Int32)

.NET Framework (current version)
 

Retrieves Char, NChar, NText, NVarChar, text, varChar, and Variant data types as a TextReader.

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

C#
C++
F#
VB
Copy 
public:
virtual TextReader^ GetTextReader(
	int i
) override

Parameters

i
Type: System::Int32

The column to be retrieved.

Return Value

Type: System.IO::TextReader^

The returned object.

Exception Condition
InvalidOperationException

The connection drops or is closed during the data retrieval.

The SqlDataReader 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.

IndexOutOfRangeException

Trying to read a column that does not exist.

InvalidCastException

The returned type was not one of the types below:

  • char

  • nchar

  • ntext

  • nvarchar

  • text

  • varchar

SqlException exceptions raised from TextReader are thrown as IOException exceptions; check the inner exception for the SqlException.

Null values will be returned as an empty (zero bytes) TextReader.

GetChars will raise an InvalidOperationException exception when used on an object returned by GetTextReader when SequentialAccess is in effect.

When the connection property ContextConnection=true, GetTextReader only supports synchronous data retrieval for both sequential (SequentialAccess) and non-sequential (Default) access.

For more information, see SqlClient Streaming Support.

.NET Framework
Available since 4.5
Return to top
Show:
© 2017 Microsoft