[ajeebaj]

How to pass float datatype into sql server. My sqlserver data type is float and function data type also float. I am trying pass text box values to that
that function it shows error like input string was not currect format

[eclipsed4utoo]

you need to convert the value in the textbox to a double. and also make sure it's an actual number.

This post has been edited by eclipsed4utoo: 26 May 2009 - 04:37 AM

[noorahmad]

try to use

Convert.ToDouble(txt.Text)

~Noor Ahmad~

This post has been edited by noorahmad: 26 May 2009 - 04:40 AM

[ajeebaj]

noorahmad, on 26 May, 2009 - 03:37 AM, said:

try to use

Convert.ToDouble(txt.Text)

~Noor Ahmad~

I tried Conver.ToDouble(txt.Text) it error message like
"Cannot convert double to float"

[noorahmad]

try this

MessageBox.Show(Convert.ToDecimal(textBox1.Text).ToString());

[ajeebaj]

ajeebaj, on 26 May, 2009 - 03:23 AM, said:

How to pass float datatype into sql server. My sqlserver data type is float and function data type also float. I am trying pass text box values to that
that function it shows error like input string was not currect format

(float) Convert.ToDouble(txt.text) will work

[eclipsed4utoo]

and this is the main reason I stay away from using Float in SQL. I would suggest using the decimal datatype.

[seser]

float = Single

you can use either

Convert.ToSingle("");

float.Parse("");