MysqlConn = New MySqlConnection
MysqlConn.ConnectionString = "server=localhost;userid=root;database=stock_sales_system"
Command = New MySqlCommand("UPDATE supplier SET SupplierName=@SupplierName, Address=@Address, Telephone=@Telephone, ContactPerson=@ContactPerson, StartDate=@StartDate, Description=@Description, WHERE SupplierName=@Name", MysqlConn)
Command.Parameters.Add("@SupplierName", MySqlDbType.VarChar).Value = txtSupplierName.Text
Command.Parameters.Add("@Address", MySqlDbType.VarChar).Value = txtAddress.Text
Command.Parameters.Add("@Telephone", MySqlDbType.VarChar).Value = txtTelephone.Text
Command.Parameters.Add("@ContactPerson", MySqlDbType.VarChar).Value = txtContactPerson.Text
Command.Parameters.Add("@StartDate", MySqlDbType.DateTime).Value = dtpDate.Value
Command.Parameters.Add("@Description", MySqlDbType.VarChar).Value = txtDescription.Text
Command.Parameters.Add("@Name", MySqlDbType.VarChar).Value = frmManageSuppliers.SupplierTableAdapter.GetSupplierName(frmViewSupplier.lblSupplierName.Text)
Try
MysqlConn.Open()
Command.ExecuteNonQuery()
MessageBox.Show("Supplier information updated.", "Data updated",
MessageBoxButtons.OK,
MessageBoxIcon.Information)
MysqlConn.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
MysqlConn.Dispose()
End Try
What I have tried:
i get this exception: "you have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE SupplierName='Lordos'' at line 1