converting varchar to double

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frederik Vanderhaeghe - 20 Apr 2006 15:04 GMT

Hi,

I try to cast/convert a varchar into a double but it doesn't work, i get an
error that it isn't possible to convert. What can I do?

The code is:
whereSQL += "cast(bedrag as numeric(10,2)) > '" &
Double.Parse(txtdocbedrag.Text) & "' and "

Fré

Reply to this Message

q - 20 Apr 2006 21:40 GMT

Double.Parse(txtdocbedrag.Text).ToString( )

(You are taking a string... making it a double... and then trying to
use it as a string. Why?)

Reply to this Message

Frederik Vanderhaeghe - 21 Apr 2006 09:29 GMT

I'm not taking a string, making it double and then using it as a string
again.
In the database there is a field (bedrag) that is from the type varchar.
In my application I have a textbox in which the value is entered as text.
But I have to compare the database field with the textbox field if the value
is greater than, greater than or equal, ...
So I convert the database field to a double and I convert the textfield to a
double and then compare them, but the convert of the database field gives an
error:
Error converting data type varchar to numeric.
What do I have to do?

> Double.Parse(txtdocbedrag.Text).ToString( )
>
> (You are taking a string... making it a double... and then trying to
> use it as a string. Why?)

Reply to this Message

Richard Troy-Rex - 21 Apr 2006 05:30 GMT

I don't have experiences on this.
But I have some confused issues.
I remembered it has type 'Double' in T-SQL
I think you should use instance of type 'Double' under .NET to store value
of type 'Double' under T-SQL but not type 'numeric'.

Reply to this Message

converting varchar to double

Free Magazines