Share via


IResultSet.GetAsciiStream Method

Definition

Overloads

GetAsciiStream(Int32)

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

GetAsciiStream(String)

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

GetAsciiStream(Int32)

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

[Android.Runtime.Register("getAsciiStream", "(I)Ljava/io/InputStream;", "GetGetAsciiStream_IHandler:Java.Sql.IResultSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public System.IO.Stream? GetAsciiStream (int columnIndex);
[<Android.Runtime.Register("getAsciiStream", "(I)Ljava/io/InputStream;", "GetGetAsciiStream_IHandler:Java.Sql.IResultSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member GetAsciiStream : int -> System.IO.Stream

Parameters

columnIndex
Int32

the first column is 1, the second is 2, ...

Returns

a Java input stream that delivers the database column value as a stream of one-byte ASCII characters; if the value is SQL NULL, the value returned is null

Attributes

Exceptions

if a database error happens.

Remarks

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.

<B>Note:</B> All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

Java documentation for java.sql.ResultSet.getAsciiStream(int).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Applies to

GetAsciiStream(String)

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

[Android.Runtime.Register("getAsciiStream", "(Ljava/lang/String;)Ljava/io/InputStream;", "GetGetAsciiStream_Ljava_lang_String_Handler:Java.Sql.IResultSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public System.IO.Stream? GetAsciiStream (string? columnLabel);
[<Android.Runtime.Register("getAsciiStream", "(Ljava/lang/String;)Ljava/io/InputStream;", "GetGetAsciiStream_Ljava_lang_String_Handler:Java.Sql.IResultSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member GetAsciiStream : string -> System.IO.Stream

Parameters

columnLabel
String

the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns

a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the value returned is null.

Attributes

Exceptions

if a database error happens.

Remarks

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.

<B>Note:</B> All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Java documentation for java.sql.ResultSet.getAsciiStream(java.lang.String).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Applies to