Loading a char value from an SQL parameter - Crashing!

[Fred Nelson]

Hi:

Newby Question:

I have the following code in a class library that performs a query on an SQL
database and is returning a class that contains "locatestatus":

if (p_locatestatus.Value != System.DBNull.Value)
{ rtrec.locatestatus = (char)p_locatestatus.Value; };

rtrec.locatestatus is a char.

This compiles just fine however it causes an error and is trapped by my
try/catch everytime. There must be something that I need to do to convert a
char - all other types are converting just fine.

Any info on the steps I'm missing would be greatly appreciated!

Thanks,

Fred

[Bruce Wood]

What exception does it generate?

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

Hi,

why don't you set a breakpoint in the if line and see the type of
p_locatestatus.Value, a quickwatch will do the trick.

Also what about using Convert.ToChar instead of the cast?
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Fred Nelson" <fr**@smartybird.com> wrote in message
news:eH**************@TK2MSFTNGP10.phx.gbl...

Hi:

Newby Question:

I have the following code in a class library that performs a query on an
SQL
database and is returning a class that contains "locatestatus":

if (p_locatestatus.Value != System.DBNull.Value)
{ rtrec.locatestatus = (char)p_locatestatus.Value; };

rtrec.locatestatus is a char.

This compiles just fine however it causes an error and is trapped by my
try/catch everytime. There must be something that I need to do to convert
a
char - all other types are converting just fine.

Any info on the steps I'm missing would be greatly appreciated!

Thanks,

Fred

[Fred Nelson]

Hi Bruce:

Good question - I should have included this!

It generates: System.InvalidCastException - Specified cast it not valid.

Thanks,

Fred
"Bruce Wood" <br*******@canada.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

What exception does it generate?

[Fred Nelson]

Ignacio:

Even though the parameter is defined as being SqlDbType.Char it was showing
as a string at the breakpoint.

The Convert.ToChar solved the problem for me!

Thank you very much for your help!

Fred
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:%2****************@tk2msftngp13.phx.gbl...

Hi,

why don't you set a breakpoint in the if line and see the type of
p_locatestatus.Value, a quickwatch will do the trick.

Also what about using Convert.ToChar instead of the cast?
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Fred Nelson" <fr**@smartybird.com> wrote in message
news:eH**************@TK2MSFTNGP10.phx.gbl...

Hi:

Newby Question:

I have the following code in a class library that performs a query on an
SQL
database and is returning a class that contains "locatestatus":

if (p_locatestatus.Value != System.DBNull.Value)
{ rtrec.locatestatus = (char)p_locatestatus.Value; };

rtrec.locatestatus is a char.

This compiles just fine however it causes an error and is trapped by my
try/catch everytime. There must be something that I need to do to convert a
char - all other types are converting just fine.

Any info on the steps I'm missing would be greatly appreciated!

Thanks,

Fred