title: I'm having trouble referencing Checking if an entry in an SQL Table Exists?
body: <p>BY the way, I'm new to VB.NET</p>
  
  <p>I have a form that a user will input information and it will be added to a database (if the entry does not already exist.).</p>
  
  <p>There are 6 columns in the database, which will be filled in by 6 textboxes that the user enters information into, these are First Name, last Name, Home address, City, US State, and Phone Number</p>
  
  <pre><code>Dim theQuery As String = "SELECT * FROM Salespeople WHERE FirstName=@FirstName AND LastName=@LastName AND HomeAddress=@HomeAddress AND City=@City"
  Dim repeatChecker As SqlCommand = New SqlCommand(theQuery, myconnection)
  repeatChecker.Parameters.AddWithValue("@First Name", TextBox1.Text)
          repeatChecker.Parameters.AddWithValue("@Last Name", TextBox2.Text)
          repeatChecker.Parameters.AddWithValue("@Home Address", TextBox10.Text)
          repeatChecker.Parameters.AddWithValue("@City", TextBox9.Text)
          repeatChecker.Parameters.AddWithValue("@US_State", TextBox11.Text)
          repeatChecker.Parameters.AddWithValue("@PhoneNumber", TextBox8.Text)
          Using reader As SqlDataReader = repeatChecker.ExecuteReader()
              If reader.HasRows Then
                  ' User already exists
                  MsgBox("User Already Exist!", MsgBoxStyle.Exclamation, "Add New User!")
              End If
          End Using
  </code></pre>
  
  <p>I get the error that there is incorrect syntax near 'nvarchar', and that I must declare the variable @First Name. I have no idea what to change.</p>