I want to search the empid of a name that with the characters entered in my textbox. using wildcard characters. I wrote the statement
da = new SqlDataAdapter(
"Select empID from emp where FirstName like ' "+textbox1.text+" ' % "
, connstring);
da.Fill(ds);
Is this statement correct?
Sumit Kesarwani
01-Sep-2014