Member Avatar for deanpaul.taylor

the MySql command is being skipped and the error being execute within th Try Catch..
Please help of possible

Dim myConnString = ";" & _
       "Database = inventory;" & _
       "Uid = root;" & _
       "Pwd = root;" & _
       "Connect Timeout = 30;"

       Dim myupdateconnection As New MySqlConnection(myConnString)

       Dim commandUpdate As New MySqlCommand("UPDATE tblcustomer SET FirstName = '" & fName.Text & "'," & _
                                             "LastName = '" & lName.Text & "'," & _
                                             "Address = '" & addr.Text & "'," & _
                                             "StateProvince = '" & state.Text & "'," & _
                                             "ZipCode = '" & zip.Text & "'," & _
                                             "Country = '" & country.Text & "'," & _
                                             "Phone = '" & cNumber.Text & "'," & _
                                             "Fax = '" & fax.Text & "', " & _
                                             "WHERE CustomerID = '" & id.Text & "' ", myupdateconnection)



       Try
           myupdateconnection.Open()
           commandUpdate.ExecuteNonQuery()

       Catch
           MessageBox.Show("Error")
       Finally
           myupdateconnection.Close()
       End Try
  • 2 Contributors
  • 1 Reply
  • 155 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

What do you mean by "the MySql command is being skipped"? Please remove the TRY/CATCH/FINALLY/END TRY statements and post the exact text of the error message that is displayed. Your MsgBox which displays only "ERROR" is useless for debugging. It would also greatly help if you were to post the resulting SQL commandUpdate text.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.