I am writting a database based inventory system and the company I work for is insistant upon MySQL. I have connection capabillities and can read and delete all day. The SQL insert statements are giving me nightmares. I need to send a string from a txtbox to the database. here is my insert statement. If anyone can please take a look at the syntax and let me know what I have done wrong.
Code:
Me.OdbcCommand1.Connection.Open()
Pleas dont delete me is the test table I have been using, and ESN is the field to insert the new data into.
Code:
Me.OdbcCommand1.CommandText = "INSERT INTO please_dont_delete_me (ESN) VALUES (txtesn.text)"
thanks