Java.Sql.IPreparedStatement.SetNull Method
Sets the value of a specified parameter to SQL NULL.

Syntax

[Android.Runtime.Register("setNull", "(IILjava/lang/String;)V", "GetSetNull_IILjava_lang_String_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetNull (int paramIndex, int sqlType, string typeName)

See Also

Types

Parameters

paramIndex
the parameter number index, where the first parameter has index 1.
sqlType
the SQL type of the parameter, as defined in java.sql.Types.
typeName
the fully qualified name of a UDT or REF type - ignored if the parameter is not a UDT.

Exceptions

TypeReason
Java.Sql.SQLExceptionif a database error happens.

Remarks

Sets the value of a specified parameter to SQL NULL. This version of setNull should be used for User Defined Types (UDTs) and also REF types. UDTs can be STRUCT, DISTINCT, JAVA_OBJECT and named array types.

Applications must provide the SQL type code and also a fully qualified SQL type name when supplying a NULL UDT or REF. For a UDT, the type name is the type name of the parameter itself, but for a REF parameter the type name is the type name of the referenced type.

[Android Documentation]

Requirements

Namespace: Java.Sql
Assembly: Mono.Android (in Mono.Android.dll)
Assembly Versions: 0.0.0.0
Since: Added in API level 1