String format error input string was not in a correct format

The input string was not in a correct format error might occur when you try to convert a non-numeric string from the input into an int. Moreover, you’ll get the said error while storing the input values that are larger than the range of the int data type as int. This post explains the causes stated above to give you clarity before you read about the solutions.

Continue reading to see how to solve the error and get your program back on track.

Why the Input String Was Not in a Correct Format Error Occur?

The given error occurs when you attempt to convert non-numeric data into an int. Also, exceeding the limit of the int data type to store larger values will give you the same error. Here are the detailed explanations of the causes:

– Converting the Non-numeric Data in Text Boxes Into Int

Are you working on a Windows Form and getting the above error? Well, the issue might be with converting the data of the empty text boxes when the form loads for the first time. So, here the erroneous code might be the one that attempts to convert an empty string from the text box into an int.

This line of code might throw the mentioned error when called inside the constructor:

lucky_number = Int32.Parse(luckyTextBox.Text);

– You Are Using Int With Input Values Larger than the Int Range

If the input provided by the user is larger than the range of int data type and you attempt to store the same in an int column, then the stated error occurs.

How To Fix the Format Error Found With the Strings?

You can fix the given error by putting into use the below solutions as per your need:

– Use the Int.TryParse() Method

As the text boxes are always empty when the form is loaded for the first time, you should use the Int.TryParse() method instead of the Int32.Parse() method. It will ensure that the error isn’t thrown even if the empty strings are attempted to be converted.

Replace the above line of code with the following:

lucky_number = Int.TryParse(luckyTextBox.Text);

– Use Varchar Instead of Int To Fix the Input String Was Not in a Correct Format Error

You should use the varchar data type instead of int to store any values that are larger than the range of int. It will most probably solve the error.

FAQ

Here you’ll find some additional information that will help you in your coding routine:

– What Is an ‘Input’ String?

An ‘input’ string refers to the data passed to a computer through a peripheral device such as a keyboard. A good example of this can be the data that you fill in the text boxes of an online form.

– How To Ensure That the ‘Input’ String Matches a Particular Format?

You can use a variety of methods including the regular expressions and loops to check if the given input string matches a particular format. Indeed, the regular expressions offer a quick and easy way to ensure the correctness of the string format. Moreover, using the loops can be helpful when you want to check each character of the string individually. So, it depends on your program requirements and the logic that you are trying to implement.

– How To Get Rid of Number Format Exception in Java?

You can resolve the number format exception in Java by checking if the string that you are trying to parse contains a numeric value. It is because the given exception occurs when you convert a string that doesn’t fulfill the requirements of an integer data type. Now, the name of the stated exception might be clear to you as well.

Conclusion

You don’t need to be worried anymore regarding the error discussed in this article. Indeed, it can be solved easily if you implement the stated solutions. Please look here for one-liner solutions:

• Input string was not in a correct format error occurs when you convert non-numeric data into an int or exceed the limit of the int data type.
• You should use Int.TryParse instead of Int32.Parse method to get rid of the said error
• You should store large numeric values in a column with a varchar data type

Never forget to match the destination data type with input data to avoid such kind of errors in the future.

Ive made a registration form(using asp.net and C#) with some attributes like username, password,date of birth,phone no,address, gender, postal code etc. There’s no error in the code.
But When I run my web site and fill in the details, and press the OK button, I get an error:»Input string was not in a correct format.»
Plz help me!

the code is:

private void ExecuteInsert(string Username, string Password, string Confirmpassword, string EmailID, string Firstname, string Lastname, string Address, string City,string State, string Country, string Postalcode,string PhoneNo, string gender, string DOB)
        {
       
            SqlConnection con = new SqlConnection(" Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Online job portal\App_Data\database.mdf;Integrated Security=True;User Instance=True");

            string sql = "INSERT INTO ojb1(Username,Password,ConfirmPassword,EmailID,Firstname,Lastname,Address,City,State,Country,Postalcode,PhoneNo,Gender,DOB) VALUES" + "(@Username,@Password,@ConfirmPassword,@EmailID,@Firstname,@Lastname,@Address,@City,@State,@Country,@Postalcode,@PhoneNo,@Gender,@DOB)";

            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand(sql, con);
                SqlParameter[] param = new SqlParameter[14];

                param[0] = new SqlParameter("@Username", SqlDbType.VarChar, 50);
                param[1] = new SqlParameter("@Password", SqlDbType.VarChar, 50);
                param[2] = new SqlParameter("@ConfirmPassword", SqlDbType.VarChar, 50);
                param[3] = new SqlParameter("@EmailID", SqlDbType.VarChar, 50);
                param[4] = new SqlParameter("Firstname", SqlDbType.VarChar, 50);
                param[5] = new SqlParameter("Lastname", SqlDbType.VarChar, 50);
                param[6] = new SqlParameter("Address", SqlDbType.VarChar, 50);
                param[7] = new SqlParameter("City", SqlDbType.VarChar, 50);
                param[8] = new SqlParameter("State", SqlDbType.VarChar, 50);
                param[9] = new SqlParameter("Country", SqlDbType.VarChar, 50);
                param[10] = new SqlParameter("Postalcode", SqlDbType.Int, 100);
                param[11] = new SqlParameter("PhoneNo", SqlDbType.Int,100);
                param[12] = new SqlParameter("Gender", SqlDbType.Char, 10);
                param[13] = new SqlParameter("DOB", SqlDbType.VarChar, 50);


                param[0].Value = Username;
                param[1].Value = Password;
                param[2].Value = Confirmpassword;
                param[3].Value = EmailID;
                param[4].Value = Firstname;
                param[5].Value = Lastname;
                param[6].Value = Address;
                param[7].Value = City;
                param[8].Value = State;
                param[9].Value = Country;
                param[10].Value = Postalcode;
                param[11].Value = PhoneNo;
                param[12].Value = gender;
                param[13].Value = DOB;

                for (int i = 0; i < param.Length; i++)
                {
                    cmd.Parameters.Add(param[i]);
                }
                cmd.CommandType = CommandType.Text;
                cmd.ExecuteNonQuery();
            }

            catch (SqlException ex)
            {
                string msg = "Insert Error";
                msg += ex.Message;
                throw new Exception(msg);

            }
            finally
            {
                con.Close();
            }
           
        }
        
    
     
    
 public static void ClearControls(Control Parent)

    {

        if (Parent is TextBox)

        { (Parent as TextBox).Text = string.Empty; }

        else

        {

            foreach (Control c in Parent.Controls)

                ClearControls(c);

        }

    }
    protected void Next1_Click(object sender, EventArgs e)
    {
        if (password.Text == confirmpass.Text)
        {
            ExecuteInsert(username.Text, password.Text, confirmpass.Text, EmailID.Text, firstname.Text, Lastname.Text, Address.Text, City.Text, State.Text, Country.Text,Postalcode.Text,Phoneno.Text,Gender.SelectedItem.Text,DOB.Text);
            Response.Write("Record was successfully added");
            ClearControls(Page);
        }
        else
        {
            Response.Write("password did not match");
            password.Focus();
        }
    }

[{«Business Unit»:{«code»:»BU059″,»label»:»IBM Software w/o TPS»},»Product»:{«code»:»SSWHLP»,»label»:»IBM Security Secret Server»},»ARM Category»:[{«code»:»a8m0z0000001hkjAAA»,»label»:»Secret Server->POLICY»}],»ARM Case Number»:»TS003931243″,»Platform»:[{«code»:»PF025″,»label»:»Platform Independent»}],»Version»:»10.7.0″,»Line of Business»:{«code»:»LOB24″,»label»:»Security Software»}}]