Search using textbox value and wildcard character

Anonymous User 2425 29 Aug 2014

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?

Ask by Anonymous User

Updated 01 Sep 2014

1 Answers

Sumit Kesarwani 01 Sep 2014

string sql = "SELECT empID " +            
"FROM emp " +              
"WHERE FirstName like @FirstName";
using(var con = new SqlConnection(connstring))
using (SqlCommand command = new SqlCommand(sql, con))
{
   
command.Parameters.AddWithValue("@FirstName",  textbox1.text + "%");
    using(var da = new SqlDataAdapter(command))
    {
        da.Fill(ds);
    }
}

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Search using textbox value and wildcard character

Can you answer this question?

1 Answers