Search using textbox value and wildcard character
<p>I want to search the empid of a name that with the characters entered in my textbox. using wildcard characters. I wrote the statement </p>

<pre><code>da = new SqlDataAdapter(
 "Select empID from emp where FirstName like ' "+textbox1.text+" ' % "
   , connstring); 
da.Fill(ds);
</code></pre>

<p>Is this statement correct?</p>
