Private Sub BtnEditCus_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnEditCus.Click
Dim Query As String
con.Open()
Query = "UPDATE Customer SET CustomerName ='" + txtNameCus.Text + "'"
Query = Query + "Sex = " + txtSexCus.Text
Query = Query + "Address = " + txtAddressCus.Text
Query = Query + "Telephone = " + txtTelCus.Text
Query = Query + " WHERE CustomerID = " + txtIdCus.Text
Dim cmd As MySqlCommand = New MySqlCommand(Query, con)
MsgBox(Query)
Dim i As Integer = cmd.ExecuteNonQuery()
'If (i > 0) Then
'lblMsg.Text = "Record is Successfully Updated"
' lblMsg.Text = "Record is not Updated"
'End If
con.Close()
End Sub