IPreparedStatement.SetBinaryStream Method

Definition

Overloads

SetBinaryStream(Int32, Stream, Int64)

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

SetBinaryStream(Int32, Stream, Int32)

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

SetBinaryStream(Int32, Stream)

Sets the designated parameter to the given input stream.

SetBinaryStream(Int32, Stream, Int64)

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

[Android.Runtime.Register("setBinaryStream", "(ILjava/io/InputStream;J)V", "GetSetBinaryStream_ILjava_io_InputStream_JHandler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetBinaryStream (int parameterIndex, System.IO.Stream? x, long length);
[<Android.Runtime.Register("setBinaryStream", "(ILjava/io/InputStream;J)V", "GetSetBinaryStream_ILjava_io_InputStream_JHandler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetBinaryStream : int * System.IO.Stream * int64 -> unit

Parameters

parameterIndex
Int32

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

x
Stream

the java input stream which contains the binary parameter value

length
Int64

the number of bytes in the stream

Attributes

Exceptions

if a database error happens.

Remarks

Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. The data will be read from the stream as needed until end-of-file is reached.

<B>Note:</B> This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Added in 1.6.

Java documentation for java.sql.PreparedStatement.setBinaryStream(int, java.io.InputStream, long).

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

SetBinaryStream(Int32, Stream, Int32)

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

[Android.Runtime.Register("setBinaryStream", "(ILjava/io/InputStream;I)V", "GetSetBinaryStream_ILjava_io_InputStream_IHandler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetBinaryStream (int parameterIndex, System.IO.Stream? x, int length);
[<Android.Runtime.Register("setBinaryStream", "(ILjava/io/InputStream;I)V", "GetSetBinaryStream_ILjava_io_InputStream_IHandler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetBinaryStream : int * System.IO.Stream * int -> unit

Parameters

parameterIndex
Int32

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

x
Stream

the java input stream which contains the binary parameter value

length
Int32

the number of bytes in the stream

Attributes

Exceptions

if a database error happens.

Remarks

Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. The data will be read from the stream as needed until end-of-file is reached.

<B>Note:</B> This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Java documentation for java.sql.PreparedStatement.setBinaryStream(int, java.io.InputStream, 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

SetBinaryStream(Int32, Stream)

Sets the designated parameter to the given input stream.

[Android.Runtime.Register("setBinaryStream", "(ILjava/io/InputStream;)V", "GetSetBinaryStream_ILjava_io_InputStream_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetBinaryStream (int parameterIndex, System.IO.Stream? x);
[<Android.Runtime.Register("setBinaryStream", "(ILjava/io/InputStream;)V", "GetSetBinaryStream_ILjava_io_InputStream_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetBinaryStream : int * System.IO.Stream -> unit

Parameters

parameterIndex
Int32

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

x
Stream

the java input stream which contains the binary parameter value

Attributes

Exceptions

if a database error happens.

Remarks

Sets the designated parameter to the given input stream. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. The data will be read from the stream as needed until end-of-file is reached.

<B>Note:</B> This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

<B>Note:</B> Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setBinaryStream which takes a length parameter.

Added in 1.6.

Java documentation for java.sql.PreparedStatement.setBinaryStream(int, java.io.InputStream).

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