Hello,

I am using a MySQL database which is connected to Visual Studio Community Edition 2017. I have a TabControl Form with several tabs in it. I have used the following vb.net code to update textbox data: -

Private Sub btnEmployeeUpdateDetails_Click(sender As Object, e As EventArgs) Handles btnEmployeeUpdateDetails.Click

If incrementdecrement = -1 Then
incrementdecrement = 0
End If

Dim conn As New MySqlConnection
conn.ConnectionString =
"server=localhost;Port=3306;database=winery_trackers;userid=root;password=mypassword;persistsecurity info=True"
Dim da As MySqlDataAdapter = New MySqlDataAdapter("SELECT * From Employees", conn)
Dim cb = New MySqlCommandBuilder(da)


'To update the records in the mysql database
ds.Tables("Employees").Rows(incrementdecrement).Item(1) = txtEmployeeProfile.Text.ToString
ds.Tables("Employees").Rows(incrementdecrement).Item(2) = txtEmployeeName.Text.ToString
da.Update(ds, "Employees")

MsgBox("Data Updated", MsgBoxStyle.OkOnly)
End Sub

However, after I have added a Binding Navigator menu to my form, this update button control no longer works.

Thank you in advance.