convert tinyint to boolean

[tshad]

I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

Is there a simple way to do this other then

isTrue = false
if ((int)dbReader["IsTrue"] == 1)
isTrue = true;

Thanks,

Tom

[tshad]

"tshad" <ts***@dslextre me.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

Is there a simple way to do this other then

isTrue = false
if ((int)dbReader["IsTrue"] == 1)
isTrue = true;

Turns out I can't do

if ((int)dbReader["IsTrue"] == 1)

or

if (((int)dbReader["IsTrue"]) == 1)

I still get the same error.

Yet, the debugger shows the value to be 1.

Thanks,

Tom

>
Thanks,

Tom

[Tom Dacon]

How about:

isTrue = (dbReader("IsTr ue") <0

Tom Dacon
Dacon Software Consulting

"tshad" <ts***@dslextre me.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

Is there a simple way to do this other then

isTrue = false
if ((int)dbReader["IsTrue"] == 1)
isTrue = true;

Thanks,

Tom

[tshad]

"Tom Dacon" <td****@communi ty.nospamwrote in message
news:Oz******** ******@TK2MSFTN GP05.phx.gbl...

How about:

isTrue = (dbReader("IsTr ue") <0

Actually, it would be something like:

isTrue = (int)dbReader["IsTrue"] != 0;

or

isTrue = ((int)dbReader["IsTrue"]) != 0;

but I get the same error.

Thanks,

tom

>
Tom Dacon
Dacon Software Consulting

"tshad" <ts***@dslextre me.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>>I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

Is there a simple way to do this other then

isTrue = false
if ((int)dbReader["IsTrue"] == 1)
isTrue = true;

Thanks,

Tom

[Ignacio Machin ( .NET/ C# MVP )]

On Jul 29, 1:36*pm, "tshad" <ts...@dslextre me.comwrote:

"Tom Dacon" <tda...@communi ty.nospamwrote in message

news:Oz******** ******@TK2MSFTN GP05.phx.gbl...

How about:

isTrue = (dbReader("IsTr ue") <0

Actually, it would be something like:

isTrue = (int)dbReader["IsTrue"] != 0;

or

isTrue = ((int)dbReader["IsTrue"]) != 0;

but I get the same error.

Thanks,

tom

Tom Dacon
Dacon Software Consulting

"tshad" <ts...@dslextre me.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

Is there a simple way to do this other then

isTrue = false
if ((int)dbReader["IsTrue"] == 1)
* *isTrue = true;

Thanks,

Tom- Hide quoted text -

- Show quoted text -

what error r u getting?

[Ignacio Machin ( .NET/ C# MVP )]

On Jul 29, 1:06*pm, "tshad" <ts...@dslextre me.comwrote:

I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

Is there a simple way to do this other then

isTrue = false
if ((int)dbReader["IsTrue"] == 1)
* * isTrue = true;

Thanks,

Tom

isTrue = Convert.ToBoole an( dbReader["IsTrue"])
should do the trick, there is no need to cast it

WARNING, you have to make sure that the value is not null because it
will fail then

[Jeroen Mostert]

tshad wrote:

I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

The SQL TINYINT type is mapped to the .NET "Byte" type. While you can cast a
byte to an int, you can't cast a byte boxed as an object to int, as that
will not invoke any conversions.

Is there a simple way to do this other then

isTrue = false
if ((int)dbReader["IsTrue"] == 1)
isTrue = true;

This will not work either, for the same reason.

Ignacio already answered this one. Use Convert.ToBoole an directly and don't
involve any casts. If the value can be NULL, you have to check:

isTrue = !dbReader.IsDBN ull(dbReader.Ge tOrdinal("IsTru e")) &&
Convert.ToBoole an(dbReader["IsTrue"]));

Or:

object o = dbReader["IsTrue"];
isTrue = o != DBNull.Value && Convert.ToBoole an(o);

If you feel confident, you can cast the column to byte, but then everything
will break if it's ever changed to smallint, int or bit (none of which are
unlikely).

--
J.

[tshad]

"Ignacio Machin ( .NET/ C# MVP )" <ig************ @gmail.comwrote in
message
news:55******** *************** ***********@m45 g2000hsb.google groups.com...
On Jul 29, 1:36 pm, "tshad" <ts...@dslextre me.comwrote:

"Tom Dacon" <tda...@communi ty.nospamwrote in message

news:Oz******** ******@TK2MSFTN GP05.phx.gbl...

How about:

isTrue = (dbReader("IsTr ue") <0

Actually, it would be something like:

isTrue = (int)dbReader["IsTrue"] != 0;

or

isTrue = ((int)dbReader["IsTrue"]) != 0;

but I get the same error.

Thanks,

tom

Tom Dacon
Dacon Software Consulting

"tshad" <ts...@dslextre me.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have
tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

Is there a simple way to do this other then

isTrue = false
if ((int)dbReader["IsTrue"] == 1)
isTrue = true;

Thanks,

Tom- Hide quoted text -

- Show quoted text -

>what error r u getting?

I figured it out, but the error was:

"Specified cast is not valid".

The problem was that I was using a tinyint and needed to use byte (short
didn't seem to work, either).

Thanks,

Tom

[tshad]

"Jeroen Mostert" <jm******@xs4al l.nlwrote in message
news:48******** *************** @news.xs4all.nl ...

tshad wrote:

>I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

The SQL TINYINT type is mapped to the .NET "Byte" type. While you can cast
a byte to an int, you can't cast a byte boxed as an object to int, as that
will not invoke any conversions.

That was what I found out, and did this to solve the problem:

IsTrue = (byte)dbReader["IsTrue"] == 1;

But I like Ignacios way better.

Thanks,

Tom

>

>Is there a simple way to do this other then

isTrue = false
if ((int)dbReader["IsTrue"] == 1)
isTrue = true;

This will not work either, for the same reason.

Ignacio already answered this one. Use Convert.ToBoole an directly and
don't involve any casts. If the value can be NULL, you have to check:

isTrue = !dbReader.IsDBN ull(dbReader.Ge tOrdinal("IsTru e")) &&
Convert.ToBoole an(dbReader["IsTrue"]));

Or:

object o = dbReader["IsTrue"];
isTrue = o != DBNull.Value && Convert.ToBoole an(o);

If you feel confident, you can cast the column to byte, but then
everything will break if it's ever changed to smallint, int or bit (none
of which are unlikely).

--
J.

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Jeroen Mostert wrote:

tshad wrote:

>I have a value in my sql table set to tinyint (can't set to bit).

I am trying to move it into a boolean field in my program and have tried:

isTrue = (int)dbReader["IsTrue"]

and

isTrue = Convert.ToBoole an((int)dbReade r["IsTrue"])

Both give me a "Specified cast is not valid".

The SQL TINYINT type is mapped to the .NET "Byte" type. While you can
cast a byte to an int, you can't cast a byte boxed as an object to int,
as that will not invoke any conversions.

The funny looking:

(int)(byte)dbRe ader["IsTrue"]

should work.

Ignacio already answered this one. Use Convert.ToBoole an directly and
don't involve any casts. If the value can be NULL, you have to check:

isTrue = !dbReader.IsDBN ull(dbReader.Ge tOrdinal("IsTru e")) &&
Convert.ToBoole an(dbReader["IsTrue"]));

Or:

object o = dbReader["IsTrue"];
isTrue = o != DBNull.Value && Convert.ToBoole an(o);

If you feel confident, you can cast the column to byte, but then
everything will break if it's ever changed to smallint, int or bit (none
of which are unlikely).

I have the exact opposite opinion.

I like the cast.

Because if the field get changed from TINYINT to INT then I will like
to see a cast exception, because if the range 0-255 is too small,
then converting it to a boolean is most likely wrong !

Arne