[Mono-list] Cast a char(1) to a boolean
Sat, 23 Oct 2004 12:16:23 -0700
Iain McCoy wrote:
>On Sat, 2004-10-23 at 07:22 +0200, Sijmen Mulder wrote:
>>>I was told to use a char(1) in a MySQL database since it doesn't have a
>>>boolean type. I retrieve a char(1) field but I can't seem to cast it to
>>>be a boolean. How is this done?
>>bool thebool = (int)thechar==0 ? false : true;
>Ow, ow. It hurts.
>Okay, I'm exaggerating. It's not really that bad, but that code is, as
>far as I can see, needlessly complicated. All you need to do is this:
>bool thebool = (thechar == 'T');
>That's assuming you define an uppercase T to represent true, and
>everything else to be a false.
>This might be a better definition:
>bool thebool = (thechar != '\0');
>Basically, just pick some character to be either true or false, and test
>for that. Assign the result of a test to a boolean.
>I'm fairly sure that that's the sanest approach to take.
Thanks for your replys. I'm still having a problem. Here is a code
ds = dbManager.GetState(ref conn);
dt = ds.Tables;
foreach (DataRow dr in dt.Rows)
if ((char)dr[ "running"] == 'T')
ds is a DataSet, dt is a DataTable and the value is being returned in an
object of type DataRow. If I run it I get the runtime error:
Unhandled Exception: System.InvalidCastException: Cannot cast from
source type to destination type.