Access Database boolean and invalid cast

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access database column is set to true/false checkboxes
DataSet Table is set to boolean type

the following conditionals fail if the Access checkbox is "true" (i get invalid cast exceptions)

if ((bool)row["Resolved"]){...

if((bool)row["Resolved"]==true){...

if(row["Resolved"].ToString()=="True"){..

WHat the hell am i doing wrong????
thanks
 
Hi,

You might check that type the column really is and what data it holds:
object o = row["Resolved"];
then inspect o.
If the value is null you get an exception in your typecasting, also.

or check table.Columns["Resolved"].DataType to see the column's type.
 
One of the problems with Jet Yes/No fields (which I'm assuming your
checkboxes are based on) is that they aren't true Booleans, being also
able to contain null as well as t/f values. One way to get around this
is to not allow null values by always supplying a default value in the
table definition, and in your code always using zero (0) for
comparison purposes (zero is always false, everywhere).

--Mary
 
Back
Top