title: check if primary key exist
body: <p>I have tried posting this earlier and had to delete it because the code editor did not post it correctly and incompletely. plus I had a member ask me about SQL injection. </p>
  
  <p>Here's the story:</p>
  
  <p>I have a page where the user can check his information before it is submitted to the database. All I want to do is look to see if that primary key is present before I submit it to avoid getting a server error. </p>
  
  <p>In my page load event I have the following:</p>
  
  <pre><code>SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString);
  
  SqlCommand oldcmd = new SqlCommand("SELECT * from dbo.registrar WHERE [MY ID] = '"+ID+"'", conn);
  oldcmd.CommandType = CommandType.Text;
  
  SqlDataAdapter da = new SqlDataAdapter(oldcmd);
  DataTable dt = new DataTable();
  da.Fill(dt);
  
  if (dt.Rows.Count &gt;= 1)
  {
     lblExists.Visible = true;
     lblExists.ForeColor = System.Drawing.Color.Red;
     lblExists.Text = "Oops! Our records show that you have already signed up for this service. Please check your information or contact your administrator for further assistance.";
  }
  </code></pre>
  
  <p>The label fires even though there is no record in the database which tells me that I am doing it wrong.</p>