converting a string to a double in vb .net

[nigel_rennie]

well heres how my story goes. I have gotten this information out of a tab deliminated file and now am trying to conver on of the fields to a double. The field is the star rating for a hotel and can be any of 1 - 1.5 - 2 - 2.5 ....etc.

 

It doesnt sound complex however i am getting an error when i try do this - here is the error:

 

An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll

 

Additional information: Input string was not in a correct format.

 

And this comes form the code:

 

Dim tempdbl As Double = System.Convert.ToDouble(tempstring)

 

Apart from this i can only imagine that i have to actually do something with the formatting of the data. It is actually coming through alright as i have viewed it in a text box.

 

Thanks for any help

Nigel

[Joe Mamma]

upload your file. lets have a look

[techmanbd]

If it is a number without anything else try using trim.

 

tempstring.trim

 

There might be spaces you don't see on either side.

[Nerseus]

If there are thousands separators or a decimal format that's not "standard" from your OS, you might need to supply a NumberFormatInfo object.

 

Here's a sample that shows how to expand on the "CurrentInfo", determined by your machine. You can also create a NumberFormatInfo from scratch and fill in all the properties.

// The following is 123456.789 in US or 123456,789 in most other countries
string s = "123.456,789";

// The following will NOT work on a US system
//decimal d = System.Convert.ToDecimal(s);

// Specify the exact formatting you expect
NumberFormatInfo i = (NumberFormatInfo)NumberFormatInfo.CurrentInfo.Clone();
i.NumberDecimalSeparator = ",";
i.NumberGroupSeparator = ".";
decimal d = System.Convert.ToDecimal(s, i);

 

-ner

[nigel_rennie]

sorry guys i am just being an idiot

 

I left the column titles in the database - couldnt convert rating to a double - or coarse. Its the little things that make you mad when you over look them - oh well thats programming i guess.

 

Thanks for your help i only noticed it because i was trying to see what i had to trim :)

 

Later Nige

[MatP]

Hi,

 

I have a similar problem with the error "Input string was not in a correct format"

 

Here's the part of my code I get stuck onto:

 

dim tmpString as String
dim myValue as Single

tmpString = "0.0000"
myValue = System.Single.Parse(tmpString)

 

 

I tried also with Decimal and Double, and with System.Convert Method... I always get the same error.

 

Thanks for the help,