SqlDataReader.GetTextReader(Int32) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Retrieves Char, NChar, NText, NVarChar, text, varChar, and Variant data types as a TextReader.
public:
override System::IO::TextReader ^ GetTextReader(int i);public override System.IO.TextReader GetTextReader(int i);override this.GetTextReader : int -> System.IO.TextReaderPublic Overrides Function GetTextReader (i As Integer) As TextReaderParameters
- i
- Int32
The column to be retrieved.
Returns
The returned object.
Exceptions
- 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.
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
Remarks
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(Int32, Int64, Char[], Int32, Int32) will raise an InvalidOperationException exception when used on an object returned by GetTextReader(Int32) when SequentialAccess is in effect.
For more information, see SqlClient Streaming Support.