IRowSet.SetNull 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.
Overloads
| SetNull(Int32, Int32) |
Sets the designated parameter in this |
| SetNull(String, Int32) |
Sets the designated parameter to SQL |
| SetNull(Int32, Int32, String) |
Sets the designated parameter in this |
| SetNull(String, Int32, String) |
Sets the designated parameter to SQL |
SetNull(Int32, Int32)
Sets the designated parameter in this RowSet object's SQL
command to SQL NULL.
[Android.Runtime.Register("setNull", "(II)V", "GetSetNull_IIHandler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetNull (int parameterIndex, int sqlType);[<Android.Runtime.Register("setNull", "(II)V", "GetSetNull_IIHandler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetNull : int * int -> unitParameters
- parameterIndex
- Int32
the first parameter is 1, the second is 2, ...
- sqlType
- Int32
a SQL type code defined by java.sql.Types
- Attributes
Exceptions
if an error occurs accessing the database.
Remarks
Sets the designated parameter in this RowSet object's SQL command to SQL NULL.
<B>Note:</B> You must specify the parameter's SQL type.
Java documentation for javax.sql.RowSet.setNull(int, 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
SetNull(String, Int32)
Sets the designated parameter to SQL NULL.
[Android.Runtime.Register("setNull", "(Ljava/lang/String;I)V", "GetSetNull_Ljava_lang_String_IHandler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetNull (string? parameterName, int sqlType);[<Android.Runtime.Register("setNull", "(Ljava/lang/String;I)V", "GetSetNull_Ljava_lang_String_IHandler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetNull : string * int -> unitParameters
- parameterName
- String
the name of the parameter
- sqlType
- Int32
the SQL type code defined in java.sql.Types
- Attributes
Exceptions
if an error occurs accessing the database.
Remarks
Sets the designated parameter to SQL NULL.
<B>Note:</B> You must specify the parameter's SQL type.
Added in 1.4.
Java documentation for javax.sql.RowSet.setNull(java.lang.String, 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
SetNull(Int32, Int32, String)
Sets the designated parameter in this RowSet object's SQL
command to SQL NULL.
[Android.Runtime.Register("setNull", "(IILjava/lang/String;)V", "GetSetNull_IILjava_lang_String_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetNull (int paramIndex, int sqlType, string? typeName);[<Android.Runtime.Register("setNull", "(IILjava/lang/String;)V", "GetSetNull_IILjava_lang_String_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetNull : int * int * string -> unitParameters
- paramIndex
- Int32
the first parameter is 1, the second is 2, ...
- sqlType
- Int32
a value from java.sql.Types
- typeName
- String
the fully qualified name of an SQL UDT or the type
name of the SQL structured type being referenced by a REF
type; ignored if the parameter is not a UDT or REF type
- Attributes
Exceptions
if an error occurs accessing the database.
Remarks
Sets the designated parameter in this RowSet object's SQL command to SQL NULL. This version of the method setNull should be used for SQL user-defined types (UDTs) and REF type parameters. Examples of UDTs include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.
<B>Note:</B> To be portable, applications must give the SQL type code and the fully qualified SQL type name when specifying a NULL UDT or REF parameter. In the case of a UDT, the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it.
Although it is intended for UDT and REF parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the typeName parameter is ignored.
Java documentation for javax.sql.RowSet.setNull(int, int, 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
SetNull(String, Int32, String)
Sets the designated parameter to SQL NULL.
[Android.Runtime.Register("setNull", "(Ljava/lang/String;ILjava/lang/String;)V", "GetSetNull_Ljava_lang_String_ILjava_lang_String_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetNull (string? parameterName, int sqlType, string? typeName);[<Android.Runtime.Register("setNull", "(Ljava/lang/String;ILjava/lang/String;)V", "GetSetNull_Ljava_lang_String_ILjava_lang_String_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetNull : string * int * string -> unitParameters
- parameterName
- String
the name of the parameter
- sqlType
- Int32
a value from java.sql.Types
- typeName
- String
the fully-qualified name of an SQL user-defined type;
ignored if the parameter is not a user-defined type or
SQL REF value
- Attributes
Exceptions
if an error occurs accessing the database.
Remarks
Sets the designated parameter to SQL NULL. This version of the method setNull should be used for user-defined types and REF type parameters. Examples of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.
<B>Note:</B> To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-defined type the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it.
Although it is intended for user-defined and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.
Added in 1.4.
Java documentation for javax.sql.RowSet.setNull(java.lang.String, int, 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.