forum

Home / DeveloperSection / Forums / Search using textbox value and wildcard character

Ask Question

Search using textbox value and wildcard character

Anonymous User 2173 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?

c#
Updated on 01-Sep-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Sumit Kesarwani

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);
    }
}

Liked By