title: Why I'm getting Incorrect syntax near ')' error?
body: <p>I'm trying to create a registration page using C# on Visual Basic 2012. When I debug I get 0 errors, but when I try to register an account I get the following error.</p>
  
  <blockquote>
    <p>"Incorrect syntax near ')'"</p>
  </blockquote>
  
  <p>If I try to create an account with an existing username it says that username already exist. So I'm able to connect to the SQL server, but I'm not sure where I went wrong.</p>
  
  <p>This registration page should create accounts in my DB DNMembership> Table> Accounts</p>
  
  <p>Here is my code I'm working with.</p>
  
  <pre><code>{
      SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegDNMembershipConnectionString"].ConnectionString);
      con.Open();
      string insCmd = "Insert into Accounts (AccountName, Passphrase, EmailAddress, FullName, Country)";
      SqlCommand insertUser = new SqlCommand(insCmd, con);
      insertUser.Parameters.AddWithValue("@AccountName", TextBoxUN.Text);
      insertUser.Parameters.AddWithValue("@Passphrase", TextBoxPass.Text);
      insertUser.Parameters.AddWithValue("@EmailAddress", TextBoxEA.Text);
      insertUser.Parameters.AddWithValue("@FullName", TextBoxFN.Text);
      insertUser.Parameters.AddWithValue("@Country", DropDownListCountry.SelectedItem.ToString());
  
      try
      {
          insertUser.ExecuteNonQuery();
          con.Close();
          Response.Redirect("Login.aspx");
      }
      catch(Exception er)
      {
          Response.Write("&lt;b&gt;Something Really Bad Happened... Please Try Again.&lt; /br&gt;&lt;/b&gt;");
          Response.Write(er.Message);
  }
  </code></pre>
  
  <p>What did I do wrong?</p>