[ad_1]
I’m receiving this error
Incorrect syntax error near “table name”
This is a part of my code
Using con As New SqlClient.SqlConnection("Server=xxx.xxx.x.x,1433;Database=XX;User ID=xxxxx;Password=xxxxxxxxx")
con.Open()
Dim cmd As New SqlCommand("SELECT * FROM User WHERE Username=@user AND Password=@pass", con)
cmd.Parameters.AddWithValue("@user", TextBox1.Text)
cmd.Parameters.AddWithValue("@pass", TextBox2.Text)
cmd.ExecuteNonQuery()
Dim adap As New SqlDataAdapter(cmd)
Dim tab As New DataTable
adap.Fill(tab)
End Using
I’m using SQL Server 2022
[ad_2]