Hi,

I have an sqlCommand return the ID from the last inserted row.  I use SELECT SCOPE_IDENTITY within the SQL.

When I call the function it returns a Decimal instead of an integer??

So I want to convert this to an integer, however this is not liked by the compiler since the overloaded method for the decimal conversion is obviously a decimal, but the ExecuteScalar parameter is of type object.

iReturnVal = decimal.ToInt32(_sqlCommand.ExecuteScalar());  <--- compiler complains....

So I changed to this:

iReturnValue =  decimal.ToInt32((decimal)_sqlCommand.ExecuteScalar());

Can someone tell me if this is the right way to do it? Seems messy code to me...

swaino:

iReturnVal = decimal.ToInt32(_sqlCommand.ExecuteScalar());  <--- compiler complains....

Decimal.toint32? I thought it was convert.toint32?

It should already be an integer.

Well decimal. provides loads of conversion functions.

Also ExecuteScalar does return an object not an integer..