how to convert datatable into float

Question

i am filling datatable from db.below code

SUM(CONVERT(float, REPLACE(Quantity, CHAR(0), ''))) as Quantity,

from datatable now i need to convert into float so i tried below code

float s1 = 0;
foreach (DataRow _dr in obj_dt.Rows)
{
   s1 = _dr.Field<float>("Quantity");
}

but its showing error

Specified cast is not valid.

where i made error.

The error should specifically indicate what the *actual* type of the object is. What is it? — Servy, Jan 15 '14 at 18:21
Which version of .NET are you using? @Servy: older versions didn't indicate the actual type. — John Saunders, Jan 15 '14 at 18:22
Use `double` http://stackoverflow.com/questions/122523/why-is-a-sql-float-different-from-a-c-sharp-float — Cam Bruce, Jan 15 '14 at 18:22

T McKeown · Accepted Answer · 2014-01-16T13:58:05.480

0

do this:

s1 = Convert.ToDouble( _dr["Quantity"]);

or

s1 = (float) _dr["Quantity"];

edited Jan 16 '14 at 13:58

answered Jan 15 '14 at 18:21

T McKeown

@T McKeown , @Happy , it there Convert.ToFloat() method in lib..? – SiwachGaurav Jan 16 '14 at 07:04
actually... float.Parse(stringVal) or Convert.ToDouble() is what should be used. – T McKeown Jan 16 '14 at 13:57

score 0 · Answer 2 · answered Jul 23 '20 at 23:30

0

Below code worked for me : float.Parse(_dr["Quantity"].ToString());

answered Jul 23 '20 at 23:30

SiwachGaurav · Answer 3 · 2014-01-16T07:00:20.470

-3

you are doing down casting in wrong manner, you have need to correct you statement as

float s1 = 0;
foreach (DataRow _dr in obj_dt.Rows)
{
 s1 = Convert.ToSingle(_dr["Quantity"]);
}

done

edited Jan 16 '14 at 07:00

answered Jan 15 '14 at 18:42

SiwachGaurav

You shouldn't convert a numeric value to a string, just to parse it again as a numeric value, just to unbox it. – Servy Jan 15 '14 at 18:55

3 Answers3