VB.NET MySQL Fatal Error But database accepts input -
i fatal error when execute code, info still shows in database. can see error here?
sql.runquery("insert test(test1,test2,test3) values(?fname,?lname,?dob)") sql.sqlcmd.parameters.addwithvalue("?fname", gender.selecteditem) sql.sqlcmd.parameters.addwithvalue("?lname", age) sql.sqlcmd.parameters.addwithvalue("?dob", rdiage) sql.sqlcmd.executenonquery()
your code should looks like:
dim connstring string = "database=yourdb;data source=localhost;"; connstring +="user id=youruserdb;password=dbpass" dim conn new mysqlconnection(connstring) dim cmd new mysqlcommand() try conn.open() cmd.connection = conn cmd.commandtext = "insert test(test1,test2,test3) values(@fname,@lname,@dob)" cmd.prepare() cmd.parameters.addwithvalue("@fname", gender.selecteditem) cmd.parameters.addwithvalue("@lname", age) cmd.parameters.addwithvalue("@dob", rdiage) cmd.executenonquery() conn.close() catch ex mysqlexception console.writeline("error: " & ex.tostring()) end try
Comments
Post a Comment