CODEWITHSUNDEEP
.net
Simon
Simon

Reputation: 6152

What's a good way of converting 1 or 0 to a boolean value?

I have a database with where boolean values are stored as bits (1 for true, 0 for false). What's the best way of converting these into .Net boolean values from a DataRow? Convert.ToBoolean doesn't seem to work.

Upvotes: 0

Views: 203

Answers (3)

Guffa
Guffa

Reputation: 700472

If the data type in the database is bit, then you don't have to do any conversion at all. The database driver automatically reads the values as booleans, all you have to do is to unbox the value:

bool value = (bool)row["field"];

Upvotes: 4

Dokie
Dokie

Reputation: 304

bool flag = (row[0]["Flag"] != DBNull.Value) ? Convert.ToBoolean(row[0]["Flag"]) : false

should work. However you may want to think about how to treat the NULL value case as here it is deemed to be set to false which you may or not wish to be the case.

Upvotes: 1

user151323
user151323

Reputation: 

bool flag = (row[0]["Flag"] != DBNull.Value) ? (bool)row[0]["Flag"] : false;

Upvotes: 3

Related Questions