dbreader class : IsDBNull(int) method
Description
Returns a value that indicates whether the value is null.
Syntax
instance.IsDBNull(int columnIndex)
Arguments
Class | Name | Description |
int | columnIndex | Column index. |
Return value
Class | Description |
bool | Whether the value is null. |
Sample code
1: | connection cnn = new connection("Data Source=c:\somedirectory\somedatabase.sqlite3;Version=3;"); |
2: | cnn.Open(); |
3: | command cmm = new command("select * from sometable where id < 100;", cnn); |
4: | dbreader dbr = cmm.Reader(); // Command execution. Returns multi-line results. |
5: | while(dbr.Read()) |
6: | bool isnull = dbr.IsDBNull(0); |
7: | endwhile |
8: | dbr.Release(); |
9: | cmm.Release(); |
10: | cnn.Close(); |
11: | cnn.Release(); |
Notes
Returns true if the specified column is null. Otherwise, returns false.
The argument should specify in a 0-based index.
If the column corresponding to the argument does not exist, an exception, UnknownException, will be thrown.
Links for reference
None.