Specified cast is not valid.

Question

0.00/5 (No votes)

See more:

.NET4.5

public Int16 UserTypeID { get; set; }
us.UserTypeID = reader.GetInt16((Int16)reader["UserTypeID"]); plz help me

Posted 14-Mar-14 0:26am

satheeshkumar chinnadurai

Add a Solution

Comments

ravikhoda 14-Mar-14 6:36am

did you check what value your reader is getting from the database? if is integer or not.

satheeshkumar chinnadurai 14-Mar-14 6:37am

tinyint

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2014-03-14T00:41:00

Solution 1

Try:

C#

us.UserTypeID = (Int16)reader["UserTypeID"];

Posted 14-Mar-14 0:41am

OriginalGriff

Comments

satheeshkumar chinnadurai 14-Mar-14 6:41am

same error i am getting

OriginalGriff 14-Mar-14 6:47am

OK - you need to look at exactly what you are getting back.
You say the data type is tinyint - so casting to int16 shoudln't be a problem, unless the value returned is null - have you set the DB column to "allow nulls" "No"?
If not, that could be the problem. Try this:
object o = reader["UserTypeID"];
if (o == DbNUll.Value)
{
// Log or report the problem - I don't know what system you are working with, so I can't tell you exactly
}
else
{
us.UserTypeID = (Int16) o;
}

If that doesn't help, put a breakpoint on the "if" and look at what is in "o" with the debugger.

satheeshkumar chinnadurai 14-Mar-14 6:56am

Specified cast is not valid. again i am getting same error this line us.UserTypeID = (Int16) o;

OriginalGriff 14-Mar-14 7:25am

So what does the debugger say is in the variable "o"?

satheeshkumar chinnadurai 14-Mar-14 7:43am

i cann't understand

OriginalGriff 14-Mar-14 7:49am

OK - you say you "checked immdiate window", so you know how to use the debugger. If you have the code I show above, and you put a breakpoint on the "if" line, what does the immediate window say is in the variable "o" when it hits the breakpoint?

satheeshkumar chinnadurai 14-Mar-14 7:51am

o == DBNull.Value
false
o
1
i Checked immdiate window return this value

OriginalGriff 14-Mar-14 8:13am

Well...I'll be a monkeys uncle!
I've not seen that before, but you can't even explicitly cast from an implicit byte to an Int16! That's *stupid!*

Fortunately, it's fixable:
us.UserTypeID = (Int16) (byte) reader["UserTypeID"];
That'll work!

satheeshkumar chinnadurai 19-Mar-14 8:23am

us.UserTypeID = Int16.Parse(reader["UserTypeID"].ToString()); i got solution

satheeshkumar chinnadurai 14-Mar-14 6:44am

reader["UserTypeID"]; but i checked immdiate window it coming

satheeshkumar chinnadurai 19-Mar-14 8:22am

us.UserTypeID = Int16.Parse(reader["UserTypeID"].ToString()); finally i got solutions