Home Notices Documents Classes Download Others Rice
Classes  >  dbreader  >  IsDBNull(int)
dbreader class : IsDBNull(int) method

Description

Gets a value indicating whether the value of given column is null.

Syntax

dbreaderInstance.IsDBNull(int columnNumber)

Arguments

ClassNameDescription
intcolumnNumberA column number.

Return value

ClassDescription
boolA value indicating whether the column 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. A multi-line result is returned.

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

None.

Links for reference

None.

Copyright © Rice All rights reserved.