title: Search command using session variable asp.net
body: <p>I have a name stored in a session variable called "name".
  I have written the statement:</p>
  
  <pre><code>da = new SqlDataAdapter("Select empID from emp where empFirstName=' "+
                           Session["name"].ToString() + " '", connstring);
  da.Fill(ds);
  </code></pre>
  
  <p>I have verified that the session variable is not empty. Yet i am not able to fetch the empID of the record that exists in the table. Is this statement correct?</p>