Computed field in temp table causes error in .NET

[John Dalberg]

I am getting "Input string was not in a correct format" error in a line
like this:
Int32.Parse(((DataRowView)e.Item.DataItem).Row.ItemArray[8].ToString())

Field #8 comes from a SQL Server stored proc. The stored proc returns a
select statement from a temp table. The temp table was created by a select
into statement like this select .........., 0.5 * another column into #temp

What data type does #8 have in the framework when it's returned by ado.net?
Because when I use the debugger and have a watch on the object returned,
the object is a number however inside the watch window, it doesn't have a
curly braces nor double quotes around it so I am guessing it's not pure
number nor a string.

What format is the object in that's causing the above error?

TIA

John Dalberg

 

[Bruce Barker]

select 0.5

will return a float. Int32.Parse() only supports a string. also even if you
convert to a string, Parse does not support decimal points. you can cast a
float to int. but if you are just trying to truncate:

Math.Floor((double)((DataRowView)e.Item.DataItem).Row.ItemArray[8])).ToString())

-- bruce (sqlwork.com)