C# - mysql ExecuteNonQuery suddenly crashing -

-

so c# code started give me error when want storedata.executenonquery

here code:

string constring = @"data source=someip; port=3306; initial catalog=saleskicker; user id=root; password=hurrdurr;integrated security=true;"; mysqlconnection saleskicker; saleskicker = new mysqlconnection(constring);  saleskicker.open();  mysqlcommand storedata = new mysqlcommand("insert saleskicker (bedrijfsname, contpers, telnum, e-mail, land, plaats, postcode)" + "values (@bedrijfsnaam, @contpers, @telnum, @e-mail, @land, @plaats, @postcode)", saleskicker);                  try {                     storedata.parameters.addwithvalue("@bedrijfsnaam", txxbvname.text);                     storedata.parameters.addwithvalue("@contpers", txxcontpersn.text);                     storedata.parameters.addwithvalue("@telnum", convert.toint32(txxtelnr.text));                     storedata.parameters.addwithvalue("@e-mail", txxemail.text);                     storedata.parameters.addwithvalue("@land", txxland.text);                     storedata.parameters.addwithvalue("@plaats", txxplaats.text);                     storedata.parameters.addwithvalue("@postcode", txxpostcode.text);                 } catch (exception)                 {                     messagebox.show("er zijn ongeldige gegevens ingevoerd!");                 }                 storedata.executenonquery();                 saleskicker.close();                 this.navigationservice.navigate(new doelen());

this worked fine before gives me this:

enter image description here

what doing wrong here?

this code worked before, must have changed in mean time what?

thanks in advance


Comments

Post a Comment

Popular posts from this blog

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:...
Read more

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5); ...
Read more