Re: Create contact with the MySQL database in the localhost

[Gabriela Martinez Sanchez]

Hi Gunnar,

Here's an example of how to make an insert on a table:

Dim myConnectionString = "Database=Test;Data Source=localhost;User Id=username;Password=pass;Port=3307;"
Dim myConnection As New MySqlConnection(myConnectionString)
Dim myInsertQuery As String = "INSERT INTO Orders (id, customerId, amount) Values(1001, 23, 30.66)"
Dim myCommand As New MySqlCommand(myInsertQuery)
myCommand.Connection = myConnection
myConnection.Open()
myCommand.ExecuteNonQuery()
myCommand.Connection.Close()

Notice that the parameters in the connection string has a semicolon as separator for each pair value.
Also for INSERT commands you can use ExecuteNonQuery. Since you won't be receiving any data as a result of the operation.

Everything else looks fine.

You can see more examples at the documentation:

http://dev.mysql.com/doc/refman/5.0/es/connector-net-examples-mysqlcommand.html#connector-net-examples-mysqlcommand-executereader

Hope this helps.