Loading a char value from an SQL parameter - Crashing!

  • Thread starter Thread starter Fred Nelson
  • Start date Start date
F

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
 
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,
 
Hi Bruce:

Good question - I should have included this!

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

Thanks,

Fred
 
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
 
Back
Top