[Nick86]

Hi,

I keep getting the following error message:

"Input string was not in a correct format."

The Error message points to this line of code:

stadiumid = int.Parse(getfileNameUpdate[1]);

here is the full code:

        public void AddStadiumsToDB(string[] stadiums, string donepath)
        {
            int stadiumid = 0;

            foreach (string stadia in stadiums)
            {
                string[] getFileName = stadia.Split('\\');
                string[] getfileNameUpdate = getFileName[getFileName.GetUpperBound(0)].Split('.');
                string[] getfileupdate = getFileName[0].Split('{','}');
                string movepath = donepath + getFileName[getFileName.GetUpperBound(0)];
                string movepathUpdate = donepath + getfileNameUpdate[0];
                stadiumid = int.Parse(getfileNameUpdate[1]);
                addSpreadsheetDataToDb(stadia,stadiumid);
                File.Move(stadia, movepath);
            }
        }

Any help would be appreciated

MOD EDIT: When posting code...USE CODE TAGS!!!

This post has been edited by JackOfAllTrades: 11 February 2011 - 04:28 AM

[batesy3k]

maybe try

Convert.ToInt32(getfileNameUpdate[1]);

[JackOfAllTrades]

You're getting the error because...hold onto your hat...the value in getFileNameUpdate[1] is...wait for it...NOT AN INTEGER! My first suggestion is to find out why that's the case; where we have no example data to work from, we can't help you there. After you find out why that's the case, you should handle that as you think is appropriate in the code. One way to do this is using TryParse:

int myInt;
string badInput = "bad";
string goodInput = "42";
if (!int.TryParse(badInput, out myInt))
{
    Console.WriteLine("{0} was not an integer", badInput);
}

if (!int.TryParse(goodInput, out myInt))
{
    // This won't happen
}

Console.WriteLine("You entered {0}", myInt);

[Sergio Tapia]

Put a breakpoint where you are converting to an integer and check what value that string is holding. Is it a number? Or is it something like, "76//"? More likely than not your string is being split wrong.

[metinc]

Thx guys, this helps me to split my text codes