"Input string was not in a correct format"

[Tanzy]

Does anyone have any idea on this, I have the following code in c#

value = Convert.ChangeType(value, property.PropertyType);

value and property are recieved as

PropertyInfo property,
object value

value is an object

property.PropertyType is a type

Everything worked fine but is failing when value = "1234.56" and the property.PropertyType is an int.

It is part of some code that I have to dynamically load data into a class from a csv file, using attributes to define what type of data to insert etc.

[Staff: Warren Ashcroft]

"1234.56" is not a (stringed) integer, integers have no decimal places; try a double/decimal/float.

[Tanzy]

Thats the issue Warren.

Basically I have some code that will import data from a csv dynamically. It uses attributes on the class parameters that define what column in the csv file belongs to what property. The data in the class is an int, however, in this case for some reason the data in the file is a decimal.

Basically, all the importing is done via reflection of the class and its attributes. I then have code that does something similar to insert the data into a database creating the SQLCommand object and creating its parameters via attributes of the class.

[Staff: Warren Ashcroft]

So if the CSV can contain decimals, make sure property.PropertyType is a decimal, not an int?

[Tanzy]

Thats the way that I'm heading at the moment, they cast it to an int when placing it into the database. Was hoping, someone would know of away to avoid doing it this was. As if the client gives the file with this issue in it for other int's means that I'm going to have to change the code again.

[Staff: Warren Ashcroft]

Thats the way that I'm heading at the moment, they cast it to an int when placing it into the database. Was hoping, someone would know of away to avoid doing it this was. As if the client gives the file with this issue in it for other int's means that I'm going to have to change the code again.

I'd have thought Convert.ChangeType would have accepted the stringed double and spat out an integer, whats the error its giving? Maybe use a rounding function on all values (as doubles) to get integers if you don't want to work with doubles?

Type conversion at the database level to integer would probably just chop off the decimals.

[Tanzy]

Happy to just chop the decimals off, not worried about that. Must admit that I thought Convert.ChangeType would do the job as well. Ho... well....

The error that I go was simply "Input string was not in a correct format", which is a bugger to track down what is going on when you catch the exception a couple of layers up in the code that caused it, and the code what was running at the time could have been a few different dynamic types. Not helping was the fact that this file has about 25 fields in it.

[Staff: Warren Ashcroft]

If property.PropertyType is an int, just round down (Math.Floor) to 0 decimal places then - that shoud sort it.

[RFH Reseller: nick]

I don't use c#, but would guess that you can explicitly convert the value to an int?

int value = (int)1234.56;

[Tanzy]

In normal cituations this would work Nick. However, because everything is dynamic here the type is only know at runtime.

I ended up just making the property a decimal in the end.