c# - Input String was Not in a Correct Format -

c# - Input String was Not in a Correct Format -

i'm new in creating application using visual studio 2010 , mysql. creating application adds info database. when click add together button, there error message says input string not in right format. come in letters textbox , used varchar datatype. now, can't figure out what's problem. can help me please?

code:

private void buttonaddcompany_click(object sender, eventargs e) { string myconstring = "server=localhost;" + "database=payroll;" + "uid=root;" + "password=admin;"; mysqlconnection connection = new mysqlconnection(myconstring); mysqlcommand command = connection.createcommand(); command.connection = connection; using (mysqlconnection conn = new mysqlconnection(myconstring)) { connection.open(); using (mysqlcommand com = connection.createcommand()) { command.commandtext = "insert company(company_name, company_other_names, company_office_number, company_office_building, company_office_street, company_office_village, company_municipality_name, company_municipality_zipcode, company_province_name, company_province_zipcode, company_country_name, company_country_zipcode) values(?company_name, ?company_other_names, ?company_office_number, ?company_office_building, ?company_office_street, ?company_office_village, ?company_municipality_name, ?company_municipality_zipcode, ?company_province_name, ?company_province_zipcode, ?company_country_name, ?company_country_zipcode)"; command.parameters.add(new mysqlparameter("?company_name", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_other_names", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_office_number", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_office_building", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_office_street", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_office_village", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_municipality_name", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_municipality_zipcode", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_province_name", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_province_zipcode", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_country_name", mysqldbtype.varchar)); command.parameters.add(new mysqlparameter("?company_country_zipcode", mysqldbtype.varchar)); command.parameters["?company_name"].value = addcompname.text; command.parameters["?company_other_names"].value = addcompothername.text; command.parameters["?company_office_number"].value = addoffnumber.text; command.parameters["?company_office_building"].value = addoffbuilding.text; command.parameters["?company_office_street"].value = addoffstreet.text; command.parameters["?company_office_village"].value = addoffvillage.text; command.parameters["?company_municipality_name"].value = addoffmunname.text; command.parameters["?company_municipality_zipcode"].value = addoffmunzipcode.text; command.parameters["?company_province_name"].value = addoffprovname.text; command.parameters["?company_province_zipcode"].value = addoffprovzipcode.text; command.parameters["?company_country_name"].value = addoffcountryname.text; command.parameters["?company_country_zipcode"].value = addoffcountryzipcode.text; command.executenonquery(); messagebox.show("data saved"); } } }

screenshots:

![enter image description here][2]

not answer, maybe mutual way fighting such problems in future. if encounter such problems, simplify minimal form. in case thing like:

private void buttonaddcompany_click(object sender, eventargs e) { string myconstring = "server=localhost;" + "database=payroll;" + "uid=root;" + "password=admin;"; mysqlconnection connection = new mysqlconnection(myconstring); mysqlcommand command = connection.createcommand(); command.connection = connection; using (mysqlconnection conn = new mysqlconnection(myconstring)) { connection.open(); using (mysqlcommand com = connection.createcommand()) { command.commandtext = "insert company(company_name, /* other fields here , */ company_country_zipcode) values(?company_name, 'company_other_names', /* other hardcoded fields here , */ 'company_country_zipcode')"; command.parameters.add(new mysqlparameter("?company_name", sqldbtype.varchar)); command.parameters["?company_name"].value = addcompname.text; command.executenonquery(); messagebox.show("data saved"); } } }

this allows narrow places there typos can drive crazy. stick simplified form until problem resolved, can sure code logic correct. homecoming total code version , see if working. if not, it's typos.

c# mysql visual-studio-2010 user-input