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

Description

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

Syntax

dbreaderInstance.IsDBNull(string columnName)

Arguments

ClassNameDescription
stringcolumnNameThe column name.

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("shop");

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.