Specified cast is not valid? 1

[mtl77]

Hello,

I am getting the error "Specified cast is not valid" on the following line of code and i cannot see why:

int _totalRecords = (int) myCommand.Parameters["@TotalRecords"].Value;

@TotalRecords is a an output from a stored procedure from a sql db. It is an int.

Any ideas?

mtl77.

 

[jmcpher]

Try passing your value to Convert.ToInt32(), a cast may not always work the way you think it should.

"Programming is like sex, one mistake and you have to support it forever."

John

johnmc@mvmills.com

 

[mtl77]

Thanks jmcpher, that worked like a charm.

Can you explain why the cast would not work the first way, or is it just one of those things?

Love the quote.

mtl77

 

[obislavu]

Should be something like that (missing []):

int _totalRecords = (Int32) myCommand.Parameters["@TotalRecords"].Value;
-obislavu-

 

[jmcpher]

The Value property returns an object, and that object might not actually be an int. Convert.To*() will take an object, cast it to an IConvertible, and then call its To* function. So basically Convert does the cast by asking the object to please cast itself.

"Programming is like sex, one mistake and you have to support it forever."

John

johnmc@mvmills.com

 

[obislavu]

You no need to cast it to IConvertible and then To*:
The followings statements are working very well and is doing that:

int vReturn=0;
vReturn= (Int32)SelectCommand.Parameters["@ReturnValue"].Value;

-obislavu-