error System.Data.SqlClient.SqlException: 'Incorrect syntax near '´'.' in VB.NET (Windows Forms)

Question

Im on vb.net framework version 4.8.1
Using an online database

code

Public Class register
Private cmd As SqlCommand

Private Sub register_btn_Click(sender As Object, e As EventArgs) Handles register_btn.Click  

    Dim con As New SqlConnection  
    Dim unused As New SqlCommand  

    con.ConnectionString = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\XXXXX\Desktop\XXXXXXX\XXXXXXXX\Database1.mdf;Integrated Security=True"  
    con.Open()  


    If (fname.Text = "" Or lname.Text = "" Or gender.Text = "" Or phone.Text = "" Or email.Text = "" Or password.Text = "") Then  
        MessageBox.Show("XXXXXXX")  
    Else  
        cmd = New SqlCommand("INSERT INTO users values(´" & fname.Text & "´,´" & lname.Text & "´,´" & gender.Text & "´,´" & phone.Text & "´,´" & email.Text & "´,´" & password.Text & "´) ", con)  
        cmd.ExecuteNonQuery()  
        MsgBox("XXXXX", MsgBoxStyle.Information, "XXXXXXX")  
        Me.Hide()  
        Login.Show()  
        fname.Clear()  
        lname.Clear()  
        phone.Clear()  
        email.Clear()  
        password.Clear()  
    End If  
    con.Close()  


End Sub

Answer 1

Try normal apostrophes ' instead of ´.

To avoid further major problems, consider the Parameterized Queries instead of dangerous string concatenations.