Index and length must refer to a location within the string. Parameter name: length

[Execute0426]

hi guys i have an error with this"Index and length must refer to a location within the string.
Parameter name: length".

 

with this code:

 

  db.Open();
  MySqlCommand SQL1 = new MySqlCommand("INSERT INTO `Billing`.`tblcustomer` (`CustomerID`, `LastName`, `FirstName, `MiddleName`, `Gender`, `Address`, `ContactNo`, `E-mail`, `Payment`, `Plan`, `Status`) VALUES ('" + getCustomerID() + "', '" + textBox1.Text + "', '" + textBox2.Text + "', '" + textBox3.Text + "', '" + comboBox1.Text + "', '" + textBox4.Text + "', '" + textBox5.Text + "', '" + textBox6.Text + "', '" + comboBox2.Text + "', '" + comboBox3.Text + "', '1')", db);
 SQL1.ExecuteNonQuery();
 db.Close();
 MessageBox.Show("One data added.", "Validation", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

 

[boghy933]

Are you using Substring somewhere in the code ?

[Execute0426]

what is substring? im sorry cause im in 3rd year college.

[beingGamer]

you are trying to access character within a string using index which doesnt exist in min & max range of that string.

 

share exact line on which you are getting the exception

[Execute0426]

i don't understand. sorry

[beingGamer]

1 minute ago, Execute0426 said:

i don't understand. sorry

suppose "hello" is my string (max index can be 4)

and I try to access character located at index 10

[Execute0426]

Thanks

[Execute0426]

i try it again but it doesn't work